MsAccess / Lost of local network connection between servers / windows server 2008
Posted on 2011-09-20
Writing from France / Rennes
Issue with ACCESS 2003 on a network with 3 servers TSE
Configuration : 3 servers TSE / Load balancing / 2008 R2 64 bits
User are connected via Internet Explorer
Server TSE_N3 + msaccess.exe sur C :
Server TSE_N4 + msaccess.exe sur C :
Server TSE_N5 + msaccess.exe sur C :
Server DATA_N6 : Mybase.mdb on D:\common\Mydirectory
Ip server DATA_N6 : 10.98.251.6
We have tried three alternative COMMAND FILE for my Access application :
1 - "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "\\Data_N6\Commun\ Mydirectory \Mybase.mdb" /wrkgrp "\\Data_N6\Commun \ Mydirectory\Sécurité.mdw"
2 - "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "\\10.98.251.6\Commun\ Mydirectory \Mybase.mdb" /wrkgrp "\\10.98.251.6\Commun \ Mydirectory\Sécurité.mdw"
3 - "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "\\G:\ Mydirectory \Mybase.mdb" /wrkgrp "\\Data_N6\Commun \ Mydirectory\Sécurité.mdw"
G: is a network drive
The first one (at the beginning) ¿ we met a lot of “disk error” or “network error” with database corruption
I identify it was sometimes due to DNS
Second, we replaced DNS name by IP address ¿ it was successful
But sometimes, we get the same problem caused by command line n°1
This morning for example
- Many users connected on TSE_N5 without issue
- A few users connected on TSE_N4
o ¿ when using the command line n°2 ¿ access.exe begins OK and we get the message ‘error disk” when Mybase is starting
o ¿ when using the command line n°3 , it’ OK
For helping , when I wanted to know TSE connection on server N4 with tsadmin.msc , there was no users connected on N4
N4 was server default and it was configured like N3 and N5 in a group
I remove N4 and N3 from the group
When I want to add N4 ou N3 computer with is DNS name (that we had found by search), we cannot do it : “RPC server not available”
I have not tried to add computer with its IP address
What do you think of that ?
Thanks for help