Current directory of database (A2K SR1)

Topic

New Reply

How would I get with codes the location (full path of the directory) of a database that is opened by
(a) using File->Open in Access 2K?
( double-clicking the name of the database in Windows Explorer?

If I open a database in A2K, what does CurDir() return? The current location of MS Access or the location of my database, if the two are located in different places?

I am confused. Please help.

Reply | Quote

Replies

Application.CurrentProject.Path will give the full path to your database
Application.CurrentProject.FullName will give the full path including the filename of the .mdb file
CurDir() will give the path to the default database folder as set on Tools –> Options –> General within Access

Reply | Quote

Thanks Dottie. I use Application.CurrentProject.Path to get the path to the database.Thanks too to Tim and Charlotte for helping me.

Reply | Quote

You can also use CurrentDb.Name to return the full path and filename of the current mdb, and that will work in earlier versions of Access as well.

Reply | Quote

…
If I open a database in A2K, what does CurDir() return? The current location of MS Access or the location of my database, if the two are located in different places?
…

To your last question, CurDir() will return the path of the db.

Reply | Quote

Not necessarily. It depends on how you open the database. If you open it via a shortcut (which I always do, because of workgroups) it just gives your default directory. If you open it from the Open dialog within Access, then it will give the path. Don’t use curdir() if you want to reliably get the path to the database.

Reply | Quote

I agree with you Douglas, and reliability or the lack of it in using CurDir() caused me intermittent problem.

Reply | Quote