This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
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
This worked for me regarding launching a PowerShell window to run a python script. Thank you!
I only wish I'd found Andreas Baumgarten's answer about three hours before I did. I would only add that if the file test.txt is stored on any drive other than the C: drive (the E: drive, for example), you have to add the name of the relevant drive after the name of the computer, so the UNC path of the file would be:
\<computername>\e\junk\test.txt
Be aware, however, that in most well-administered organisations drive mappings do not vary, as they are forced at every login, thus no need to worry about UNC paths.
That's good to know. However, I needed to find out the UNC paths of files on my personal computer.
Sign in to comment