AllowBypassKey and Type Mismatch Error

[Harvey]

Hello:

I have been trying to incorporate either Albert Kallal's solution:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html

or Microsoft's:

http://support.microsoft.com/kb/826765#appliesto

and in both cases, in my Access 2003 db, I get a type mismatch error at


Set prop = db.CreateProperty("AllowByPassKey", _
dbBoolean, False)

would anyone know what the problem is here?

thank you
Harvey

 

[Tom van Stiphout]

On Wed, 11 Feb 2009 12:17:01 -0800, Harvey

Make sure that db is declared as a DAO.Database, and prop is a
DAO.Property.
Set OPTION EXPLICIT.

-Tom.
Microsoft Access MVP