MsAccess / Lost of local network connection between servers / windows server 2008
Posted on 2011-04-29
The configuration is :
Access base (.mdb) is on a server Windows 2008 R2 Enterprise (files dedicated)
Users are connected with terminal server on 4 servers (virtual server) - I think it's a cloud of TS server
Msaccess.exe is installed on each TS Server
Sometimes , it happen that the link between msacces.exe and msacces.mdb is lost and the user got the message "error disk or error network"
Msacces continue to be opened with no access to tables.
When I say "sometimes", it is no problem during a week or many times in the afternoon on only one TS server or on 2 TS server.
One time, when the problem occured, I have tried to open a session on the TS Server where the user was connected with the problem.
I could not open the session on TS server and I got a message about a lost name in DNS cache and I was advised to use Ip adress rather than DNS name of server.
Perhaps an idea to understand what's happened ?
If you need more details on configuration
Thanks for answers
Patrick / France