Code to find drive letter

[Bob Valentine]

Group:

I need help with writing code to find the drive letter of the drive where my
database application (.mde file) is located. Most users will be installing
my application on their C: drives, but others may install it on another
drive, such as their D: drive. Is there a function that can determine the
drive letter where the database file is located?

Thanks,
BobV

 

[Stefan Hoffmann]

hi Bob,

I need help with writing code to find the drive letter of the drive where my
database application (.mde file) is located. Most users will be installing
my application on their C: drives, but others may install it on another
drive, such as their D: drive. Is there a function that can determine the
drive letter where the database file is located?

Use CurrentDb.Name.


mfG
--> stefan <--

 

[Bob Valentine]

Thanks so much for the help.

hi Bob,


Use CurrentDb.Name.


mfG
--> stefan <--