Unexpected SQL Connection

[scotthutchings]

I have an Access 2007 database that I set up that is somehow connected to SQL Server. I am not entirely sure how it got connected but the current front end and back end are entirely contained in Access.

Right now, if the SQL Server services are turned off, nobody can log into the database. When the services are started, it works fine. I have installed the access software on a new server that does not have SQL Server and it will not allow the users to open the database. How do I disconnect the database from SQL Server?

Thanks in advance,
Scott

 

[Galaxiom]

Just because all of the linked tables are connected to the Access backend it does not mean the server is not connected in some other way.

Maybe passwords or other security information is stored in the server to protect it from prying eyes. It wouldn't be the first time a developer forgot something they put into a database. I know I have.

This SQL connection could be in a connection string somewhere in the VBA. The error could go unreported if some code didn't handle errors properly.

Try searching the entire VBA project for "ODBC".