Find the UNC path for a file on my computer

Question

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.

Answer 1

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).

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