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

Darren DICK d.dick at uws.edu.au
Thu Jun 17 19:01:20 CDT 2004


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



More information about the AccessD mailing list