Question

Q: Access 2010: "Error accessing file. Network connection may have been lost" This thread is locked from future replies

Hi,

I use Access 2010.
I receive this message : Error accessing file. Network connection may have been lost

It happened after:
1/ writing a VBA code
2/ closing the accdb
3/ opening the accdb
4/ trying to open the form containing the code.

The computer has no network and no server.
The last package has been installed.
And the tools supposed to be efficient on this kind of issue are helpless.

This is quite an issue because it creates complete uncertainty on the reliability of the tool.

Thanks for your help

Answer

A:

Hmmm, well before I say the corruption word...  Take a look at the tables and make sure there are no links to an external spreadsheet.

Just in case...

Could be the begining of corruption...
http://www.granite.ab.ca/access/corruption/symptoms.htm.  I would make a
back-up, make another back-up and then first try importing everything into a
new database.  Also, read this article...
http://www.granite.ab.ca/access/corruption/retrievedata.htm.  And after all
of that I would finish off with this article...
http://allenbrowne.com/ser-25.html and see if any of those circumstances
apply to you.

Gina Whipp
Microsoft MVP (Access 2010-2015)
http://www.access-diva.com/tips.html

Did this solve your problem?

Sorry this didn't help.

1 person was helped by this reply



 
Question Info

Views: 6,313 Last updated: April 22, 2018 Applies to: