find directory of mdb file

[ecawilkinson]

hi,

can anyone tell me how to find the directory of the current mdb in VBA. I do not mean the default database directory but the directory in which the actual mdb file for the current database resides in.

Thank you,
Chris

 

[RoyVidar]

If you mean the current database, try

Currentproject.Path

If you mean the path to the backend database, you can find lot of info through using

CurrentDB.TableDefs("NameOfTableInBackend").Connect

but, you'd need to strip off some excess info

 

[ecawilkinson]

Thanks. CurrentProject.path was waht I needed. I knew it was somewhere.