Alex has attended:
Excel Advanced course
Access Advanced course
Mapping Data Drives
In access you can link tables from different databases. However assume that the folder containing the database is a public folder and different users may have it mapped to different drives on their computer. Therefore if I link a table it's path could be L:publicfolder/database/table1 but if someone else goes into the database and has the public drive mapped to a different drive on their computer, then microsoft access won't find it at the above address because their public drive is on the M: drive for example. Therefore the question is whether there is a way to link tables (and generally map things) without referencing to a specific drive?
RE: Mapping Data Drives
Hi Alex,
Thank you for your question. Mapped drive letters are convenient for shortening long directory paths but as you have pointed out the letter used may vary depending on the machine being used to connect to the shared resource.
An alternative to a drive letter is to enter the full network path. These often look like:
\\servername\directory\subdirectory\myfile.xls
Check with whoever looks after your network. They should be able to give you the full path to the folder location. Since this path describes the location in full it is independent of any drive mappings the user may have and should work on any machine for a user that has permission to connect to the public drive.
I hope this helps.
Kind regards,
Andrew
