Answer for:

Using MS Access and ODBC to access an SQL Database

Message 14 of 13

View entire thread
0 Votes

My experience is that it is better to try solving by creating a brand-new database and attempt to import objects from the OLD database, rather than trying to export to a new database. It frequently seems that it ends up being usually one, maybe a couple, of objects that are corrupting the entire database.

Although the form is stored locally, it may have a control source to some linked table. The linked table may be on a database that (was) on the network. Check the form's control source. Use the linked table manager to renew the links as some of them may have had the design altered.

KB article on this error:

"When you try to view the code for a module, try to compile a database, try to create an MDE file, or try to execute code in a Microsoft Access 2000 database, you may receive one of the following error messages:
Error accessing file. Network connection may have been lost. "