Determine Directory MDB was Opened From?

D

Douglas J. Steele

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

If you use A2K or later, you can also use:

CurrentProject.Path

HTH
Van T. Dinh
MVP (Access)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine if previous "character" is a section break 3
Word VBA - Want to test if Full Name is NOT Present in document 0
database file path 6
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
I have lost 6 months work, how can i get my file back 1
Compact all mdb files in directory 1
Is there a way to determine the date? 9
Determine the drive letter of BE database... 2

Top