Get path/directory of current mdb

[John]

How do I get the current path or directory of the
database I am working in using VBA
The help file is "slightly" confusing!
And once I have it can I create directories under it?

Thanks in advance!

 

[Chris]

Are you using Access 2000/XP???


If so, then CurrentProject.Path will return the path of
the database.

Then you can MkDir to create directories.


Chris

 

[John]

Using Access2000
Thanks for the help!

Are you using Access 2000/XP???


If so, then CurrentProject.Path will return the path of
the database.

Then you can MkDir to create directories.


Chris

 

[stelios]

dim db as database
dim name as string

set db=currentdb.name 'path of the database
name=dir(db) 'database's name


Stelios T.
Greece