Your network access was interrupted. to continue close the db andopen it again

[nitoglycerine]

The db is 2007 and stored in SBS 2008. the clients are xp and vista.

one or two times in day I receive this error.

The network is reliable, no errors in the server neither in the
clients.

What can be the problem, and how can I solve it?

NiTo

 

[Stefan Hoffmann]

hi,

The db is 2007 and stored in SBS 2008. the clients are xp and vista.
one or two times in day I receive this error.
The network is reliable, no errors in the server neither in the
clients.
What can be the problem, and how can I solve it?

Is it an offline folder?

http://allenbrowne.com/Access2007.html

Otherwise create a permanent open recordset:

http://www.granite.ab.ca/access/performanceldblocking.htm

mfG
--> stefan <--

 

[nitoglycerine]

hello,

Is not an offline file.

in the second solution is there back end and front end files, in my
scenario is only one file, could be the same problem? Is the same for
2000 and 2007?

thanks,

NiTo

 

[Stefan Hoffmann]

hi,

in the second solution is there back end and front end files, in my
scenario is only one file, could be the same problem? Is the same for
2000 and 2007?

Indeed, this should solve your problem.


mfG
--> stefan <--