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

[munkee]

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\NonConf ormance 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

[Darren McDonald]

Attached sample DB;-

Cheers
Darren

[munkee]

Worked flawless, good job

Thanks