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

Thanks JC

----- Original Message ----- 
From: "jwcolby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com>
Sent: Friday, June 18, 2004 12:48 PM
Subject: RE: [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
> 
> 
> 
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com