Current Database Path

[PaulCoop]

How can I get the full path of the access database that I am running? The aim of getting this path is to create dynamic linking with a table in another access database that exists in the same directory but the database is stored in different locations on different workstations.

CurDir() doesn't work. I have tried to use the Windows API using the function GetCommandlineA from kernal32.dll but that isn't even recognised as a valid function and according to various web pages that function is known to crash under various OSs.

Any suggestions anyone?

Paul Cooper

 

[Ed2020]

Use CurrentDB.Name

Ed Metcalfe.

Please do not feed the trolls.....

 

[PaulCoop]

Talk about not see the wood for the trees.

Cheers

Paul

 

[PaulCoop]

Talk about not seeing the wood for the trees.

Cheers

Paul

 

[chickey]

If you are looking for the path and the database name
then currentdb.name is yer only man.

If you are looking for a way to get the path only without
having to go mid$'ing, then the following is the muts nuts:

Application.CurrentProject.Path

Regards...

 

[Ed2020]

Assuming he's using MS Access 2000 or 2002.....

Ed Metcalfe

Please do not feed the trolls.....

 

[PaulCoop]

Thanks Chickey, but I am using a mix of access 97 and 2000 so I will have to stick to mid$'ing

Paul

 

[danvlas]

If you use ADO: CurrentProject.FullName
In DAO: CurrentDb.Name
If you have both references, any of the above.
By default, Access 97 works with DAO and Access 2K with ADO.
Both can be changed by adding the appropriate references.
For the path, check thread702-536966

Good luck




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html