AllowBypassKey and Type Mismatch Error

11 Feb 2009 8:17 PM

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

12 Feb 2009 2:23 PM

Tom van Stiphout

On Wed, 11 Feb 2009 12:17:01 -0800, Harvey
<Har***@discussions.microsoft.com> wrote:

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

-Tom.
Microsoft Access MVP

Show quoteHide quote

>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