[AccessD] Can Access 2007 discern which folder it lives in?

Hi Brad,

To determine which folder the currently running access project lives in you
can use:

    stg = CurrentProject.Path

Also, if you are running code in a referenced access file, look at:

    stg = CodeProject.Path

HTH,
Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Friday, May 07, 2010 12:48 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Can Access 2007 discern which folder it lives in?

All,

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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com