Hi,


We have inherited a series of access projects (adp) that are user front end’s to a SQL server back end (the same SQL db is used for ALL 4 ADP’s). The current connectivity in each case is via ODBC. What are the connection alternatives when using a SQL BE? And what are the pro’s and Con’s?

I realise that this is a broad question but any help would be appreciated.


Access 2003 and SQL Server 2000


Thanks in advance,