I need help please.

I have a program where the user may specify the data path to a directory on a mapped drive. Then I open a table in the specified directory and look in a field say cDataPath that contains something like "D:\Data".

But this D is local to the machine that created the data in the first place. So I need to be able to check that I am actually mapped to this D and use my reference drive letter to access data in the d:\data directory. If my pc is not mapped to the D drive in question I need to know that, map it, used the assigned drive letter to access data.

Any help, ideas or better ways of trying to achieve this?

Thanks

Mathias