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

I had a broken table link- make sure all your linked tables work- are linked to an available drive/path/

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

Regardless of what the error message says, you can also get this error for a database on a local drive. In such instance the error is due to the inability of Access to write to the drive. To remedy the situation, do the following:-

1. Ensure the drive on which the database is situated is not write-protected.
2. Ensure you can create a file and delete in the location where the database is situated.
3. Run Windows disk scanner to remove read/write errors. Read/write errors can occur if your system hangs due to a hardware fault and you had to restart the computer.

Hopes this helps.

Thanks

Bindi Gill

Malaysia

This is such a nuisance behavior. Searching online doesn’t show any solutions.

Does rebooting help?

NO!

Yesterday I faced this same problem, and I was not able to find anything useful in the Internet. I got it SOLVED! so I write here to share my case and solution:

The reason why I was getting this misleading error message was THE USER running my application: My application is a SERVICE, so user is not the one logged on the computer, but, according to the task manager, user is SYSTEM.

My service is written in Java, and it was trying to connect to a MS Access 2007 .accdb database, getting the error message "Your network access was interrupted. To continue close the database and then open it again".

If I run my service changing "log on as" from "local system account" to "this account" and I enter the user & password used to log on Windows, the problem disappears! As you see, it has nothing to do with closing database and opening it again, and it has nothing to do with network access interruption. An ERROR_ACCESS_DENIED (0x5) would have been much much clearer...  ;-)

More than likely you have linked tables in your database. SMB does not let the old share name resolve. Go into link table manager and look how the unc name for the link table is listed. Change the name of unc to the proper name. It could be as simple as you created your links with drive letters instead of the unc name for example  you should use \\servername\share instead of v:\servername\share.

In my case the old \\servername\share was unreachable by my winows 7 laptop but was accessible by my xp laptop due to SMB. The storage administrator had change the name of the servername to a new name and aliased the old name.  I used the new \\newservername\share name when I updated the link. FYI, the linked table manger will prompt you for a path and you can browse to the location, nut it will use a drive letter if you mapped the drive. To use the UNC name just type it in the filename box instead of browsing to it for example \\newservername\share\accessdbname.mdb and click save. Do this for all links or select all and the link table manager will update all links to that unc name(Make sure all links should be updated before selecting all).

The error Network access was interrupted is partially true because MS access could not resolve the unc name.