[AccessD] Connecting to network drive

I need to link to tables in another access database but the linked table wizard wants to use a drive letter. The problem is that different users have the same drive designated with different letters. I found the following information but am unsure how to implement it. I thought I could change it in the msysobjects table but no go.


Mapped drive connections would be something like:

H:\apps\MyApplications\MyAccess.mdb



And UNC would be something like:

\\MySecondServer\apps\MyApplications\MyAccess.mdb



Chester Kaup

Engineering Technician

Kinder Morgan CO2 Company, LLP

Office (432) 688-3797

FAX (432) 688-3799





No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.