SOLUTION TO ERROR " Your network access was interrupted. To continue close the database and then open it again." __

I had this problem message today when trying to open the database. In my case the error message "Your network access was interrupted. To continue close the database and then open it again." was completely wrong.

The error message should have indicated that the database was in use. I had at the time of attempting to open the database an Excel worksheet that had a link to it. Once I closed this Excel worksheet I was able to open the database in Access. This database is setup in such a way that it is not allowing concurrent use, even by the same user - but that is a separate issue.

The initial problem had nothing to do with Network access being "interrupted"... I am sure this error message as it currently stands is leading some people down the wrong troubleshooting path. No wonder there is so much agro about Access and this error message.

In our case it was relying on group policy preferences GPP map drive configuration.

The drive from which the database was started was mapped with GPP option "replace".

This caused msaccess to loose connection when standard group policy event raised.

Solution was setting option to "update".

We discovered a subtle difference for this problem.

The back-end database was fine. We could open it from another machine without a problem. From the machine with the problem, we found we couldn't open any database on the network.

Turns out it was a problem with the workgroup security file (MDW) that it was referencing. It had gotten corrupt. Access was being launched with a shortcut that included a /wrkgrp command line parameter that pointed to that MDW file.

Once we pointed it to another MDW file, it worked fine.

Right, same mess. I don't have time to spare. As Divad_S wrote: "Like all thinks MOCOsoft (microsoft), when in doubt reboot.  I am sure glad they don't make AIRCRAFT."

Forget me.

I don't know how to do that. 

Do what? Click on the Participate link? Just scroll to the top of the page, you will see a link labeled Participate, right under the word Community. Click on it and follow the prompts to post a question.