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

I have a MS Access 2007 database with the backend on a server and the front ends on the laptop or desktop.

Every time I put the screen down of my laptop the connection is disrupted and I have to close the program and re-start it.

Does any one have a solution to this. Perhaps a routine that can be initiated to re-establish the link to the network if the connection has been lost.

I look forward to the genius.

Regards

Agree. Had the error and found 'Windows explorer' was causing the error. Checked open files on file server and explorer was open at the database location - closed it and all worked ok. Same as others in that if I copied the database to another name it worked fine - as it would as nobody had this new copy open.

This also could be a quota on user space if on a network. I had the same issue with a user who reached their quote. Once increased it allowed my user to open Access again.

I haven't had this problem for a number of months now. I no longer leave any explorer windows open and it all works fine. There have been no hardware changes and minimal software changes, but clearly, something has changed because I'm not getting disconnected any more.

One potential change to the database is the addition of an "On Timer" event which may stop this apparent time-out type problem. Perhaps you can try that? I use it to see if a user has been inactive in order to kick them out if they aren't doing anything, but even if I set it to a long duration, I still don't get the error so it might just be the periodical checking that stops the problem.

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

Does rebooting help?

NO!