linked tables and SBS

[Andrew Millar]

I'm using an Access 2002 database on an MS SBS network. I'm using
linked tables, and the path to the linked tables goes to the server.
If a user on a workstation logs off and a different user logs on, the
path to the linked table gets corrupted -- eg, S:/folder1/file1
changes to s:/file1.
I have a similar problem with MS Query in Excel.
However tables which aren't linked are fine, even if they are on the
server. There was a recent re-installation of the server software and
the all the workstations were reinsatlled also. It worked OK before.
Any help appreciated.
Andy

 

[Albert D. Kallal]

I'm using an Access 2002 database on an MS SBS network. I'm using
linked tables, and the path to the linked tables goes to the server.
If a user on a workstation logs off and a different user logs on, the
path to the linked table gets corrupted -- eg, S:/folder1/file1
changes to s:/file1.

I have not seen any posts over the years in this newsgroup that would
duplicate your above problem. However, it is common knowledge that drive
letters do change, and are a throw back to the old CPM and DOS days. As a
good practice, one should avoid drive mappings, as they can change all the
time..and even users logging on with a different script can wind up with a
different drive letter.

I would link the tables in ms-access via a UNC pathname. That is

\\ServerName\SharedFolderName

In your case..something like:

\\ServerName\file1

And, while likely just a typo, I notice that you are using forward
slashes..and not backwards ones.....

So, dump the old fashioned drive mapping idea...and use the above UNC
(servername + shared folder Name) convention..and that should help..

 

[Andy]

Thanks Albert - I'll try that some time over the next few days when I
visit the client again - and yes // should have been \\ !