Linked Tables in 2 Access Databases

  • Thread starter Thread starter cjborntorun
  • Start date Start date
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?
 
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
 
Back
Top