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,