Hello:

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

http://www.members.shaw.ca/AlbertKal.../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

On Wed, 11 Feb 2009 12:17:01 -0800, Harvey
<(E-Mail Removed)> wrote:

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

-Tom.
Microsoft Access MVP


>Hello:
>
>I have been trying to incorporate either Albert Kallal's solution:
>
>http://www.members.shaw.ca/AlbertKal.../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