Error message

We are running Access2000(frontend) SQL server (backend). When we try to either compile or run an ADE, we receive the message "Error Accesing File. Network connection may be lost". When you go to File-Connection-Test Connection- the message "The connection succeeded" pops up. Any ideas on what could be causing this error message? What can be done to repair the database in order that this does not occur? Is it improper code written somewhere? Is it possible that the import of a number of files were done and only a specified number can be brought in at a time?

Your help is appreciated.

I found this doing a Google search. I'm not sure if this applies to you. If it does, it's very bad news.

This is due to a known issue described in the following KB article:

ACC2000:Error Message: Error Accessing File. Network Connection May Have
Been Lost (Q304548)
http://support.microsoft.com/?kbid=304548

The corruption in your mdb cannot be repaired. You will need to use a recent
backup of the mdb. You may be able to import uncorrupted objects from the
damaged mdb into a new mdb and then import the corrupted objects from the
recent backup.

To *prevent* further corruption you should obtain the Office2000 Service
Pack. This issue has been resolved with this SP. For more information on
SP3 check out the following KB articles:

ACC2000: Issues Fixed in Access 2000 by Office 2000 Service Pack 3
Http://support.microsoft.com/?kbid=326605

OFF2000: Overview of Office 2000 Service Pack 3
http://support.microsoft.com/defaul...kb;EN-US;326585


*** Note *** Until you install SP3 you should be sure to compile your
project after you import or copy/paste code into any mdb *before* you close
the mdb. This will also prevent further corruption.