Can Access 2007 discern which folder it lives in?

  • Thread starter Thread starter Brad
  • Start date Start date
B

Brad

In order to simplify our "TEST to PROD" change control we would like to be
able to programmatically (in VBA) determine which folder an ACCDB lives in.

Is this possible?

Thanks,
Brad
 
Brad said:
In order to simplify our "TEST to PROD" change control we would like to be
able to programmatically (in VBA) determine which folder an ACCDB lives
in.
Click to expand...


CurrentProject.Path will return the folder in which the current database
resides.
 
Brad said:
In order to simplify our "TEST to PROD" change control we would like to be
able to programmatically (in VBA) determine which folder an ACCDB lives in.
Click to expand...

Dirk has already given you the answer.

I pretty much always distributed my FEs as MDEs/ACCDEs. So I put a
check in it that if the user is running an MDB and this is running
against the prod database the main menu form background colour is red.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
 
Back
Top