Linked Tables in 2 Access Databases

C

cjborntorun

Access database "A" has a product information table that links to an Access
database for user 1, user 2, user 3, etc. All databases are stored on the
same server in the same folder.

User 1 may have their computer profile referencing the server as drive
letter "E", and user 2 may have their computer profile referencing the server
as drive letter "T".

How can I link the table from one Access database to the other WITHOUT
reference to a drive letter?
 
J

Jerry Whittle

Instead of using mapped drives, use UNCs. Ask your network people what the
UNC is to the folder holding the database file in question and manually
update Linked Table Manager.

The UNC will look something like //mountpoint/datafolder
 

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

Similar Threads

Link table from another Access database 2
Access 2007: Can't delete linked tables in secured database 1
linked tables dissapear 1
Linked Tables Locking Up 6
Access linked databases and Windows server 2008 3
Access 2003 - Linked Tables? 2
Find Databases With Linked Tables 1
merge two same databases 7

Top