Linking a table using server name instead of mapped network drive

[alansidman]

I am attempting to link a table in one database to another database using the server name designation (ie.//2sxfprinff01\Group\) instead of the mapped network name (ie. G:\). I tried relinking using the Access Link Manager. Right click on the linked table. But it does not let you edit the link.



Access 2007 does not allow this and reverts links to the G: drive. There are situations where the the IT department have set the mappings to this shared location as an H:\ for some of the employees. In those cases, the employee gets an error message telling them that Access cannot locate the G: drive.

An obvious solution is to get the employees remapped to the G: drive. However, one would think that MS would have allowed for mapping to the designated location and not an alias. Any thoughts on this issue.

[pbaldy]

You can certainly link via UNC path. I don't know that you can edit via the linked table manager. You can via code and TableDefs. You should be able to relink via the linked table manager and navigate through network places instead of the mapped drive. If you typed in the path you may need to reverse those first 2 slashes.

[ssanfu]

Maybe this will help????

Enumerating Local and Network Drives
http://access.mvps.org/access/api/api0003.htm

[alansidman]

Thanks Steve and Paul. Will attempt to re-link later this morning.

Alan