Is there a way to do this? TIA, Dan
D Douglas J. Steele Jul 16, 2004 #2 CurrentDb().Name gives you the complete path to the database: Left$(CurrentDb().Name, Len(CurrentDb().Name) - Len(Dir$(CurrentDb()))) will give you just the path.
CurrentDb().Name gives you the complete path to the database: Left$(CurrentDb().Name, Len(CurrentDb().Name) - Len(Dir$(CurrentDb()))) will give you just the path.
V Van T. Dinh Jul 17, 2004 #3 If you use A2K or later, you can also use: CurrentProject.Path HTH Van T. Dinh MVP (Access)
