Current Directory

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I am looking for a VBA function for Access 2000 that will return my
current database directory. The GetCurrentDirectory API call that I
have found returns my current WORKING directory (I think) - it always
returns C:\Doc & Set\User\My Docs - which is not where I am running my
dB from.

Any suggetsions?
 
Ummm Yeah, it will.

Wow do I ever feel like a Dunce. Can't beleive I missed that.

Wait ... not a Dunce, life is useless unless you can learn something new
everyday, or pass something on to someone else, right?

Thanks, I appreciate it.
 
No problem. There are probably a million people who post on here who know way more than I do.
 
Access XP or higher: CurrentProject.Path (returns directory)
Earlier versions to current versions (using DAO): CurrentDB.Name (returns
full directory\filename path)
 
Back
Top