msaccess adp - how does connection work?
Posted on 2009-02-10
I have a msaccess.adp file that connects to a sql server database via window authentication. Everything was working until last week. This is the strange thing. I created an ODBC entry via the control panel connecting to the sql server via a sign in id/password. I DID not change ANYTHING about the connection int he msaccess.adp file, but now the connection works again. When I delete the ODBC entry from my machine, the msaccess.adp file doesn't work again with regards to the connection. Can someone tell me why it works when I create the ODBC entry on my machine but not change how the msaccess.adp connects to the database. Wierd. It's like the adp is using the ODBC entry when it's initial connection doesn't work. I hope someone can explain what is happening. Thanks!