Cannot Reference DB after Network Went Screwy

[Rob G]

Hello,

I have a split database (back end on the network and the front end on each
user's machine). Right or wrong, I placed some of the code in a database
that I left up on the network and set each front end to Reference that
database. That way I could make changes on my machine and then just update
the database containing the code.

Well, our network went down and now when I open the front end I get an
"Error accessing file. Network connection may have been lost."

I have gone back into References and reconnected the MDB as well as relinked
all the tables. I even see the code and can "touch" it in the front end. But
whenever I run anything, or even try a search when in the Module, I get that
"Network connection may have been lost" error.

Any ideas on what I am doing wrong?

Thanks.

-Rob

 

[Immanuel Sibero]

Hi

This happened to me sometime ago, although it was not caused by a crashed
network. I created a new database and imported all objects, it worked and I
didnt pursue any further as to the cause of the problem.

Immanuel Sibero

 

[Tim Ferguson]

Well, our network went down and now when I open the front end I get an
"Error accessing file. Network connection may have been lost."

Corrupt mdb file. Look up the MSDN and search for the error message you
got. If I remember correctly, it is recoverable.

HTH


Tim F