Ask a new question

Access 2010: "Error accessing file. Network connection may have been lost"

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
Answer

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)
https://www.access-diva.com/tips.html

1 person found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 13, 2024 Views 13,134 Applies to: