Alternatives to ODBC in Access 2000

Hello All,

Have a bit of a problem that I hope someone will be able to clarify. I have an Access 2000 mdb that connects to two SQL Servers by way of ODBC. Now due to several failures with OBDC (Would get ODBC errors when the connection to SQL was proven not to be down), my boss wants me to eliminate ODBC from the equation and directly connect to the SQL Servers. Now he has suggested I use SQLOLEDB as an alternative, but thus far I seem to only be able to implement this on the VB side of it, which would mean I'd have to send all my SELECTS UPDATES DELETES etc manually, which would turn a minor update into a complete overhaul. I know there is a way to link tables directly with SQL in Access 2002, is there a similar option in 2000, and how would I go about it?

Thanks!Did a little research and it seems possible to use ADP files with SQLOLEDB, but I don't know how or even what ADP files are.