Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Virginia, USA
    Posts
    127
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Split db - link via UNC (Access XP)

    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,

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Split db - link via UNC (Access XP)

    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.

  3. #3
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Virginia, USA
    Posts
    127
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Split db - link via UNC (Access XP)

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •