Link table from another Access database

[cjborntorun]

Access 2003: When linking a table from one Access database to another, is it
a MUST to have a literal drive letter reference?? I'm not seeing a way
around that. Each employee has their own forecasting database and I'm trying
to mimic the process for each database. However, for the linked tables it is
difficult, because they all have the source drive setup under a different
drive letter...ugh. I'm constantly having to switch back and forth when I
do maintenace on their database.

I know the employee can remap their drive to the letter I choose, but I
think this gets tricky, because they have their drive mappings sort of
hard-coded into their profile, so I'm not sure remapping the drive letter
will work 100%. thank you

 

[Roger Carlson]

You can use the UNC for linking a table. When you go to File>Get External
Data>Link Tables, go to My Network Places and browse to your file from
there. That should put the UNC (//servername/...) instead of the mapped
drive.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Jerry Whittle]

You can use a unc instead of a mapped drive letter. Check out the following:

http://www.access-programmers.co.uk/forums/showthread.php?t=41476