Split db – link via UNC (Access XP)

Topic

New Reply

How do you specify a UNC path instead of a Mapped Drive letter in a split database? I have used the “Linked Table Manager” and am able to point to any drive letter successfully. However, our network guys tell me that I need to specify the link via a UNC path. Access Help says the same:
===========
Import or link data and objects
Important: If you link to a file on a local area network, make sure to use a universal naming convention (UNC) path, instead of relying on the drive letter of a mapped network drive in Microsoft Windows Explorer. A drive letter can vary on a computer or may not always be defined, whereas a UNC path is a reliable and consistent way for Microsoft Access to locate the data source that contains the linked table.
=====================
But I can not seem to find out how to do this. Is it done programatically? Any assistance is appreciated.
Thanks,

Reply | Quote

Replies

You can type a UNC path directly into the File Name box of the Select New Location dialog, or select Network Neighborhood in the Search In dropdown list.

Reply | Quote

Thanks for the handholding. UNC links are in place. Network guys are happy. Life is good. I also found some code on this site that seems to establish and refresh links each time a db is opened.

Reply | Quote