Relative Path

[nightjam]

How do I get the current path of my access database.

I don't want to type an absolute path like below so how do I get the current path of the database?

strFile = "provider=microsoft.jet.oledb.4.0;data source=C:\data\database.mdb

 

[psemianonymous]

In newer versions of Access,

CurrentProject.Path

--
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

 

[nightjam]

What a life saver.

I tried application.path and looky here there was currentproject all this time.

Many thanks. This is great