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" <(E-Mail Removed)> wrote in message
news:EE0F1C3B-CAF3-40D1-838A-(E-Mail Removed)...
> 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.

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

(please reply to the newsgroup)

Dirk,

Thanks for the help!

Brad




"Dirk Goldgar" wrote:

> "Brad" <(E-Mail Removed)> wrote in message
> news:EE0F1C3B-CAF3-40D1-838A-(E-Mail Removed)...
> > 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.
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)
>
> .
>

Brad <(E-Mail Removed)> wrote:

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

Tony,

Good idea - I plan to try this.

Thanks,

Brad


"Tony Toews [MVP]" wrote:

> Brad <(E-Mail Removed)> wrote:
>
> >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 <(E-Mail Removed)> wrote:

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