Generalizing the path in a linked table for a network

[Paul James]

When I use the File-Get External Data-Linked Tables menu command to set up a
link to the table, the path to the table in the Description property of the
Table Properties dialog box describes the path in terms of the particular
drive mapping in my computer. But I need to deploy this front end
throughout a network, and the drive mapping I happen to use in the
development desktop is not the same mapping other users on my network may
have.

So I need to generalize the path in the table Description so that the link
will be usable for everyone on our network. I've tried typing in the
network drive specification, but Access won't save the change. Instead, the
entry in the Description property keeps reverting to the original drive
mapping.

The drive mapping I need to change is:
X:\folder1\filename.mdb; TABLE=tblData

The network mapping I would like to replace it with is:
\\fs_file\network1$\folder1\filename.mdb; TABLE=tblData

Can anyone tell me how can I change the path specification to the network
drive, and get Access to save the change?

Thanks in advance.

Paul

 

[David]

If you're browsing to the backend data file, the simplest
way of accomplishing this would be to browse via "Network
Neighborhood" (or "My Network Places", or whatever your
version of Windows labels it) to get to network server that
holds your .mdb file.

Another method would be to use a macro or vba code to
create the linked table using the UNC pathing.

Hope that helps!

David

 

[Paul James]

My question pertains to establishing a link with another table using the
File - Get External Data command on the menu. I'm not using either ADO or
DAO to do this. I'm trying to find out how to get the path specified in
terms of a UNC rather than a mapped drive.

I know this can be done because I've done it before. I just can't remember
what I did.

 

[Paul James]

Thanks, David. I forgot that I could navigate to the file through the
Network Neighborhood.