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

Anonymous
2010-11-02T01:50:09+00:00

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

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

91 answers

Sort by: Newest
  1. Anonymous
    2012-01-16T19:10:06+00:00

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

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2011-06-09T14:56:16+00:00

    The IT department I consult with reported the same problem as migration to Windows 7 and Office 2010 is underway (from XP and Access 2007). They also use a Citrix server for national support.

    The problem is only on Window 7, not on XP.

    I sent the SMB 2.0 patch code from MSDN that will also show the same error. They ran that and it did not change anything.

    http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/SBS_Small_Business_Server/Q_25594983.html

    this is a subscription site. I have yet to get an account. But, they claim to have tried seveal things with out success (listed at this link).

    Just a note: Upgraded Access 2000 to Access 2007. Front end - linked to back end. No problems with this for last year, until Windows 7 - Office 2010 roll out. Had tested compatibility on a stand-alone workstation of Wondows 7 / Office 2010 (C: / drive) to validate code, DLL, and Excel reporting automation. No problems found.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2011-06-01T08:21:31+00:00

    As an aside for anyone else getting this problem and loosing vba code as a result, it is possable to export your vb modules after you have had the error and re-import them after re-opening to avoid loosing anything.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2011-06-01T08:13:35+00:00

    I replaced my links which were using mapped drives with the full network paths (using the linked table manager - pretty quick and easy) and all references to mapped drives in my VB code, then disconnected my mapped drives (to ensure i hadn't missed any references) and re-opened the database (via the full network path).

    Unfortunately it didn't make any difference - after a few hours (and many unsaved vba changes) I got the usual network access interrupted error.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  5. Anonymous
    2011-06-01T05:18:48+00:00

    I avoid using mapped drives and use the UNC path instead.

    To use unc paths, when manually relinking, instead of using windows explorer to find the path to the backend, instead go to the network folder on the computer and navigate to the backend from there.

    The path will look something like \\Servertree\Folder name\ Backend name

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments