Perhaps someone can share information on the methods to use to effect
the automation process of creating the property to set the
AllowBypassKey function. I was directed to:
http://www.mvps.org/access/general/gen0040.htm and downloaded the
function module that includes setting the fourth DDL part to true. It
initially failed to compile using Access 97 because "PropType As
DAO.DataTypeEnum" is not an automation type that Visual Basic
supports. I received a tip to change "DAO.DataTypeEnum" to "Long" and
that allowed the module to be compiled.
I have tried a couple of methods to call the function without much
success. The last of which was using a macro in one database to effect
the change in another - ChangePropertyDDL("C:\program
files\databases\customers.mdb"), but has the wrong number of
argruments.
I would appreciate anyone's assistance in providing helpful tips
regarding the above function. Thanks, Dalan