Path for linked tables, how code ?

D

David

How do I code a path for linked tables such that different
users with different drive letters will be able to use
this system?
Please be very specific and detailed as I have not been
able to find this documented anywhere.
 
G

Gary Miller

If you can't standardize the mapping on the network, then
you can use the UNC path to the database by browsing Network
Neighborhood for the db in the Link Table Manager...

\\ServerName\SharedFolder\YourDB.mdb

This will be the same for all.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
C

Cheryl Fischer

If you have users with different drive letter assignments, the best way to
link tables for them is to use the full UNC path to the tables. It's easy.

There is code at the following link that will re-link all of your tables for
you:

http://www.mvps.org/access/tables/tbl0009.htm

Copy all of the code to a public module. You can put a command button on a
form which you do not need to make available to users. In the Click event
of the command button, just put: fRefreshLinks.

When you click the button, the default will show drive C:, but you should
navigate to Network Neighborhood and drill down until you find the Server on
which your back-end database is located. Keep on drilling down through
folders until you find your back-end database - click and the code will
relink everything for you.

hth,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top