We have an MS Access 2002 Project that connects to a SQL Server 2000 back end. Everything worked fine yesterday, but doesn't today. The project has somehow become disconnected. If I go to File > Connection, I can test the connection, and it completes successfully.
I tried creating a brand new Project. I used the upsizing wizard to take one of our MDBs and convert it to an SQL DB. The wizard completed without error and created an Access Project file to connect to the new SQL DB. Now the new Project is disconnected! I logged into the SQL Server Enterprise Manager and can see the new DB. If I simply link to the tables using an ODBC connection I can see the data, so I know the upsizing worked.
So it appears that the network connection is working fine, the SQL Server is being referenced correctly, and all should be well. Where is the option to reconnect?
Does anyone have any idea what gives?