Mysterious Error Message

[JJman]

Some months ago one database here began getting an error message when users tried to open it saying "Error accessing file. Network connection may have been lost." The network connection was fine, however. Users were completely unable to use the database, though it can be opened with the bypass key. This has now affected two more databases but the exact cause is still unknown. This ONLY happens after the admins sync objects to the production databases from their test copies. Whether they use the import utility built into Access to sync objects or use the good ole drag-and-drop method, the result is the same. It obviously has something to do with bringing in new objects, but we are clueless as to the exact problem and how to fix or avoid it. The fact that the databases can be opened just fine with the bypass key or if the database window is set to open automatically when launched (instead of any forms), leaves me all the more baffled because the two issues should be entirely unrelated. As it stands, we're having to do a lot of extra work to get around this issue. Any help is greatly appreciated!

 

[RoyVidar]

Hi!

The database might be corrupt (lot of errors might occur when importing objects...). Check out corruption symptoms here Corrupt Microsoft Access MDBs FAQ or take a look at this Microsoft link Error Message: Error Accessing File. Network Connection May Have Been Lost

To resolve, you might try this Decompile or how to reduce Microsoft Access MDB/MDE size and decrease start-up times, even though it is marketed as something else, the advice in the Microsoft link, or take a look at MakeItSo's faq faq705-4683.

Roy-Vidar

 

[JJman]

Thanks! These will be very helpful!

 

[Hap007]

Dear JJMan,

Sounds like you have 2 problems here.

1) From your description, I believe that you have your program code and Data all stored in one access db. It is better to have all your program code, forms, reports and queries placed in one Access mdb called the 'FrontEnd'. Then your data and the relationships should be stored in a second Access or SQL database called the 'Backend'. Then needed tables are linked to the Frontend.

2) Your problem, 'Network connection' maybe lost can occur for at least 2 reasons.
A) The network connection is truly lost.
B) When you import or copy forms, reports or code into an Access mdb, the very next step is to open a code window and recompile the database. You must get a good, complete compile. If you do this, then the error you describe should go away.

What is happening now, is that some form or code module is not properly compiled in the db and access can not see the code, so it tells you the network connection is lost. Oh well,

So, create a new database, set the references the same as you current db, import all your elements and then compile. This should solve youe problem.

Good Luck,
Hap



Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers

 

[JJman]

Thanks Hap! Also very good info!