Moving database to new server.

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

Hi,
I moved our access database to a new server. I changed the command buttons I
could to the new drive letter. I ran the repair and compact. Not all users
on the network can now use the database properly. It seems to still
reference the old drive. Is there something else to try to update the
database. I am currently using Access 97.

Thanks,
Terry
 
Terry,

"Not all users on the network can now use the database properly" makes me
suspect your problem is one of different drive mapping by different users
rather than a missed out drive reference during your changes. To verify,
check the mappings (in Windows Explorer) on the PC of one of the users
having the problem. If you find defferent or missing mappings then my
suspicion is correct. In that case:
Fixing the mappings on each user's PC would solve it, but this is only a
half-measure (what warranty have you got that users won't change their
mappings again?). The real, robust solution is to use UNC paths instead of
mapped drives, so instead of, e.g.:
K:\Common\be.mdb
use:
\\ServerName\Users\Common\be.mdb
The easy and safe way to get the full UNC path is to open Windows Explorer,
open Network Places, locate the target server and work your way down to the
target file. When you select it, the full UNC path will appear in the
address bar (right below the toolbar). You can simply copy and paste in your
Access application.

HTH,
Nikos
 
Back
Top