Link to home
Start Free TrialLog in
Avatar of TerenceHewett
TerenceHewett

asked on

Error accessing file. Network connection may have been lost.

Hi experts,

I have been working on a database that has been located on a drive through a network for the past year with no problems.  All of a sudden I have started getting the following error when I am in my forms:

Error accessing file. Network connection may have been lost.

I tried the obvious thing and that was to close down the system, and copy the db file to my local hard drive but I am still getting the error message. I have also rebooted the machine.  I have tried this db file on three computers and still get the error message.  Can anybody help?

Thank you.

Terry
Avatar of flavo
flavo
Flag of Australia image

Could be corupt.  Try these steps:

http:Q_21477388.html#14346433

Dave
Avatar of rockiroads
Most likely corrupt. Check out the links given my Flavo
Another thing to try is to copy one form/module etc at a time to another database. Though that may not solve it, it may help you find your corruptness.
Hope u got a backup.

Remember (my current saying of the day), Access is more flaky than Cadburys!!!

Wow, 2nd time I got to use that today
It's still as tasty though (to me anyway) ;-)

I've had that problem with a corrupt module in a form before.
If you can get to it (or a backup of the code) copy the text of the code.
Set the form's HasModule property to No.
Save - compact yadda yadda.
Open the form - HasModule yes - paste it in.

If that works big yay - if not do all the full on corruption repairing type stuff :-)

(OK - I suppose decompile isn't exactly a huge chore lol)
ASKER CERTIFIED SOLUTION
Avatar of dbase118
dbase118
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Leigh, u ever been to Cadbury's world? They give u a sample of the choclate as its being made
damn nice - sickly sweet though
Mmmm... the land of chocolate.  (Yap.. yap.. Chomp!)

(One for Dave there).
Avatar of TerenceHewett
TerenceHewett

ASKER

Thank you to all.  Dbase, that article was fab - I now have the service packs and the problem seems to have gone.

Regards,
Terry
This was one of my most hated bugs in all of Access-land. Glad the article helped.