[AccessD] A2K: Change Properties of a dB from a different dB

LOL.  You're welcome.

John W. Colby 
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Thursday, June 17, 2004 8:01 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A2K: Change Properties of a dB from a different dB


Nevermind it's working now
I found some JC code that I could pilfer :-))
Thanks JC

Darren

----- Original Message ----- 
From: "Darren DICK" <d.dick at uws.edu.au>
To: "AccessD List" <AccessD at databaseadvisors.com>
Sent: Friday, June 18, 2004 9:52 AM
Subject: [AccessD] A2K: Change Properties of a dB from a different dB


> Hello all
> If I want to change some 'properties' on the Current dB I type 
> something like
> 
>    Dim dbs As Object, prp As Variant
>    Set dbs = CurrentDb
>    dbs.Properties(strPropName) = varPropValue
> 
> That's cool but what would be the sysntax for changing a property in 
> another dB open or not
> 
> my code that works fine using the Set dbs = CurrentDb but when I tried 
> passing the
> path of another dB it doesn't apply the requested changes
> EG If I type some thing like Set dbs = C:\Program Files\MyFolder\MydB.mdb
it fails
> 
> Anyone know the correct syntax so I can alter the properties of 1 dB 
> from another?
> 
> Many thanks
> 
> Darren
> 
> 
> 
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com