473,406 Members | 2,956 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,406 software developers and data experts.

VBA or other method to get UNC path from drive lettered folder

374 256MB
Hi all,

This is probably something very simple however I cant seem to get this to work right.

I am looking to basically find out what the UNC path is to my folder which holds my database. I first figured this would be very simple by just navigating through network places but it really is just a mass of servers.

The directory is located K:\corp\NonConformance there but I have read multiple times it is a big risk to go by drive letter as these can often change. So I would like to find the UNC path.

Any help is appreciated,

Chris
Aug 20 '10 #1

✓ answered by Darren McDonald

Attached sample DB;-

Cheers
Darren

2 4086
Attached sample DB;-

Cheers
Darren
Attached Files
File Type: zip GetUNC.zip (15.1 KB, 674 views)
Aug 23 '10 #2
munkee
374 256MB
Worked flawless, good job

Thanks
Aug 23 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

14
by: Job Lot | last post by:
How can I find path of windows folder using vb.net? It could be winnt or windows depending upon the os. System.Environment.SpecialFolder enumeration does not have a constant for windows folder.
3
by: Jason Moss | last post by:
How do I copy all the contents of a cd drive (All files and subfolders) to a folder? If possible, I'd like to implement a progress bar control to tell users how much the app has copied.
4
by: Scott Glasgow | last post by:
I have the Microsoft Visual Basic .NET Deluxe Learning Edition from Microsoft and am trying to reinstall it after a hardware system crash requiring complete reformat/reinstall of Windows XP Pro and...
4
by: Dots | last post by:
I have a class library with a method called getpath(). I want to be able to get the full path of a folder and write some files to the (my_files_dir) folder. A console application will use this...
4
by: CAIBird | last post by:
hi, i'm writing a application that need to get the path of share folder "ADMIN$" on a remote machine. for instance, if "ADMIN$" is maped to "C:\Windows", i want to get the string "C:\Windows". ...
1
by: gujarsachin2001 | last post by:
Hello friends, I have one folder Named as MainFolder on server. I have one more folder named as subfolder inside tht main folder.Now I want to save some pictures in tht folder but at runtime I m...
2
by: pappu | last post by:
Hello friends, I have one folder Named as MainFolder on server. I have one more folder named as subfolder inside tht main folder.Now I want to save some pictures in tht folder but at runtime I m...
2
by: lukasz | last post by:
Hey is there a way to make certain method be called whenever any other method in my program is called (such global method hook), usable e.g. for logging or debugging?
1
by: srujana123 | last post by:
Is there any way using either IIS or Web Config or some other method that I can redirect requests to a specific subfolder to another URL? For example, when somebody types in...
0
by: amitcool1982 | last post by:
I am getting the path of share folder "ADMIN$" on a remote machine but this command have any user account issue. if it have any issues then what is the issue. If any developer have any clue then...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.