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

You also need to be careful using a flash drive in this manner. I've seen beaucoup reports over the past few years about data corruption in Access when using a flash drive in this manner. Apparently many flash drives report that data transfer is complete when, in fact, it isn't quite, and disconnecting before the transfer is complete is apt to cause corruption.

Linq ;0)>

There's always more than one way to skin a cat!

I get this problem too. As far as I have noticed, it only appears when running Access 2007 on Windows 7 (not on XP for me, and I have tried to replicate it). I have tried changing network ports, cables etc to no avail. In my set-up, I have the database split, with both parts residing on the same server. I have googled extensively for soloutions but yet to find anything useful (although I did fix other access problems - like crashing when you open tables - by uninstalling the HP protect tools which HP install needlessly on new computers).

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

The solution is in the message, close the database and reopen it. The message means that your network connection to the database was lost. either because of a network problem or the database was moved while you had it open. There is nothing else you can do but close the database on your end and hope the data doesn't get corrupted.

If the problem persists, then contact your IT department to check if there is a problem with your access to the network.

My network access in my office is somewhat iffy. So I do all my development on a local drive, because of too frequently getting this message.

Hope this helps, Scott<> P.S. Please post a response to let us know whether our answer helped or not. Microsoft Access MVP 2010 Blog: http://scottgem.spaces.live.com/blog Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports and Queries

Jeanette,

I was recently working with a client and their IT department decided to move the backend database to another server. They did it without notifying us and, although we didn't get the message the OP got, it did have the unfortunate effect of corrupting the backend. I had a "fun time" getting it repaired.

Lynn Trapp MCP, MOS, MCAS