Applecore Pages on Microsoft Access

Getting the path to the current database

If you want the path and the name of the current database, then use:

CurrentDb.Name

If you want just the name of the current database, then use:

Dir(CurrentDb.Name)

Or if you want the path to the current database, then use:

Left(CurrentDb.Name,Len(CurrentDb.Name)-Len(Dir(CurrentDb.Name)))

Top

 


HOME | NEW | TABLES | QUERIES | FORMS | REPORTS | GENERAL | API | DOWNLOADS | TUTORIAL | RESOURCES
E-MAIL
Copyright & Disclaimer

 

Last modified at 06/06/2006 14:55:44