HELP - Error Accessing file. Network connection may have been lost

[misslee1888]

I recieve the Visual Basic Error.

"Error Accessing file. Network connection may have been lost"

I have a database whic is split, anytime I try to change my front end I get the following message.

Can anyone please tell me what that means and the easiest way to avoid this.

Thanks

 

[Rob.Mills]

I've gotten this error before and haven't totally figured out what causes it. I would recommend reseting your references to dll's and libraries.

 

[office_guru]

Possible Solution

Check out this thread on this site
here

Unfortunately according to the MS link would have meant that I would have to have found the latest saved non-corupt db and go from there which was going to be a significant pain.

However I noticed that whenever VB opened it was on a different form than the one i was opening etc. What worked for me was importing all my forms, tables, queries etc except for the form that kept popping up in VB and just recreating that one. Haven't had any problems since.

Best of luck!

 

[misslee1888]

I managed to find a good copy of the front end of my db. Do you know what caused this as I don't want it to happen again?

 

[office_guru]

Import/Wizard

If I remember reading correctly on the MS website it's a problem triggered by importing or using wizards. I have a feeling it might have been playing with code that was incorrect/input inappropriately - but not certain. Lesson learned when playing with new features/functions not familiar with make sure they work then import into you db.

I think there was also recommendations on that website as to how to prevent if you're working off a certain version. Images blurry - recommend reading the site yourself.

 

[boblarson]

One other way this will come about, is when a user is connected to the database via a network and a minor disconnection occurs. This is more likely to happen on a WAN than a LAN. If the network connection is lost, even for an imperceptible period of time, this error will occur. The only way to ensure you don't lose all in that case, I've found, is to make sure you have frequent backups available.