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

Darren DICK d.dick at uws.edu.au
Thu Jun 17 18:52:13 CDT 2004


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






More information about the AccessD mailing list