Current Directory

[JaySang]

I have created a link to another database using a macro. However it requires me to enter the full path to this database. I was wondering if there is anyway of coding it so that to looks in the current directory for the file.

 

[psemianonymous]

You can't do that using a macro. Using VBA it is possible, though.

 

[JaySang]

can you do it with runcode in a macro. And if so what code would I use.

 

[psemianonymous]

This expression will return your current database's path:

Left( CurrentDB().Name, Len(CurrentDB().Name) - Len(Dir(CurrentDB().Name) )

 

[mikevh]

CurrentProject.Path also returns the path
of the current database.

 

[psemianonymous]

Yeah, do his solution if it's available. Mine works with Access 97, but his is better for 2000/2002

--
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access

Corrupt MDBs FAQ

http://www.granite.ab.ca/access/corruptmdbs.htm