Determine Directory MDB was Opened From?

[Dan]

Is there a way to do this?

TIA,
Dan

 

[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.

 

[Van T. Dinh]

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

CurrentProject.Path

HTH
Van T. Dinh
MVP (Access)