We currently have a SQL database with an Access front-end. It's clunky and everyone hates it, of course. Is there a reasonably simple way to tie a SharePoint list to a table in the database so that items can be entered in the SharePoint List
and show up in the database, and vice-versa? The reason for keeping the database is that some data is entered by users in Access, but some comes from an external source - thus, the need for a 2-way connection.
It's MOSS 2007.
View Complete Post