How to Link Tables Located on a LAN

[Guest]

I have a DB that resides on my 'H' drive. The program works for most of my
co-workers. However, when another person whose profile is different than
mine, ie. my 'H' drive is really their 'V' drive, my program errors out.

The program is linked to tables in another DB. When I go into the 'Linked
Table Manager', they are listed as 'H:\Dept\Source.mdb'.

How do I link/refer to these tables by using the network name of the drive
instead of using 'H'?

 

[Douglas J. Steele]

When you're selecting the database through the Linked Table Manager, don't
select your mapped drive. Instead, go through "My Network Places" (or
whatever it's called in your operating system) and select the MDB file that
way. That should result in a UNC being used.