Current Directory

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?
 
G

George Nicholson

Access XP or higher: CurrentProject.Path (returns directory)
Earlier versions to current versions (using DAO): CurrentDB.Name (returns
full directory\filename path)
 

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

Incorporating the User Profile location into a document template path 1
Word OLE to check spelling in text box 1
OLE Word spelling 0
Word macro that can call cells out of Excel for a find and replace 0
Access Lock File .LACCDB / Now shows as a notepad file 0
Office 2019 for mac, will it still…? 0
New computer, how do i move outlook 365 ENTIRELY? 0
Can't save my Office documents (after computer rebuild and reauthorization) 0

Top