I'd like to get the Path of a file in a Drive.
For Ex.
FileName = "Northwind.mdb"
I'd like to know the exact path of where Northwind.mdb is in my "C:" Hard Drive
or my "D:" Mapped Network Drive.
I need to get the exact path so that I can point to that Database and Compact
that Database.
I'm trying to make an Access .mdb that will compact another .mdb Database.
I'm able to do this but I have a problem with setting the Path of the Database
to Compact.

In Access CurDir() does not work because it always has "My Documents" as its value.