Can Access 2007 discern which folder it lives in?

[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

 

[Dirk Goldgar]

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.

CurrentProject.Path will return the folder in which the current database
resides.

 

[Brad]

Dirk,

Thanks for the help!

Brad

CurrentProject.Path will return the folder in which the current database
resides.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

.

 

[Tony Toews [MVP]]

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.

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/

 

[Brad]

Tony,

Good idea - I plan to try this.

Thanks,

Brad

 

[Tony Toews [MVP]]

Good idea - I plan to try this.

You're welcome. I came up with that solution due to personal and
embarrassing experience. <sigh>

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/