Referencing the drive by name

[Rich]

Hi,

I've just "inherited" support of an access database for 2 colleagues. User A
has a server called "Servername" as his J: drive, User B has the same server
as his H: drive.

The database works fine for B, but A has numerous "cannot find
J:/.../filename.mdb type errors.

I can't see any references to drive letters in the db, which sits on the
server rather than local. I don't really want to change their network paths
for a totally unconnected reason, any ideas how to cure this ?

Rich

 

[Douglas J. Steele]

Presumably the application is split into a front-end (containing the
queries, forms, reports, macros and modules), linked to the back-end
(containing the tables). When the front-end is linked to the back-end, use
UNC (uniform naming convention: \\server\share\folder\file.mdb\) instead of
J:\folder\file.mdb.

If you use the Linked Table Manager to relink the tables, you can have
Access use the UNC if you find the back-end through Network Neighborhood (or
My Network Places) rather than through the mapped drive.

 

[Larry Daugherty]

The proper way to do it is to place the Front End on each user's
desktop and then have user A go to Tools|AddIns|Linked Table Manager,
select All and force the add-in to ask for the location of the linked
table(s). Navigate to the Back End mdb on the server and click OK.
All done. If you do that then you may profit from visiting Tony
Toews's site and getting a copy of his free FE Updater.

If you just aren't place individual front ends on desktops you'll have
to either change A's link to the server to "H:". Alternatively, you
may be able to just add a second reference to the server and name it
"H:".

What ever works.

HTH