Find the UNC path for a file on my computer

Pete Royall 1 Reputation point
2021-07-13T20:41:49.59+00:00

I want to split my access database and the support.microsoft site has a handy step-by-step guide, but right at the end, throws in "The location that you choose must be available to everyone who will use the database. Because drive mappings can vary, you should specify the UNC path of the location instead of using a mapped drive letter." Absolutely no help on how to do that from microsoft support.

I have searched through several forums including this one and it's heavy with code suggestions, nearly all of which has one reply or other saying it didn't work or messed things up further. Surely someone out there knows how to find out the UNC without running all this code???

Any help appreciated.

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
810 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Andreas Baumgarten 94,196 Reputation points MVP
    2021-07-13T21:40:55.643+00:00

    Hi @Pete Royall ,

    to get the UNC path you don't need any code.

    Open the Computer Management console on the computer with the access db and click on Shared Folders -> Shares

    There you should see the shared folders of the computer (share name and location).

    114296-image.png

    Assuming the file test.txt is stored in C:\Junk the UNC path of the file is the following:
    \\<computername>\junk\test.txt
    Just replace the <computername> with the name of your computer with the file.

    ----------

    (If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

    Regards
    Andreas Baumgarten

    2 people found this answer helpful.