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