A2K: type mismatch error where there was none before

[Deano]

I'm really worried my db is falling apart!

I'm now getting;

"Run-time error: 13

Type mismatch"
When I run faq_DisableShiftKeyBypass in the immediate window. This is a
reference to the standard code to disable the ability to hit shift to get
into a database on start up.

It falls over at;

Set prop = db.CreateProperty("AllowByPassKey", _
dbBoolean, False)
I dug up quite an old version and it seems to be ok. Assuming there is
some sort of corruption going on how can I deal with it? I have decompiled
and compacted the database but that hasn't helped.

thanks
Martin

[Deano]

"Deano" <de***@mailinator.comwrote in message
news:45**********************@ptn-nntp-reader02.plus.net...

I'm really worried my db is falling apart!

I'm now getting;

"Run-time error: 13

Type mismatch"
When I run faq_DisableShiftKeyBypass in the immediate window. This is a
reference to the standard code to disable the ability to hit shift to get
into a database on start up.

It falls over at;

Set prop = db.CreateProperty("AllowByPassKey", _
dbBoolean, False)
I dug up quite an old version and it seems to be ok. Assuming there is
some sort of corruption going on how can I deal with it? I have

decompiled

and compacted the database but that hasn't helped.

For ther record I got this fixed - notice an old post on the group re the
DAO reference. I then saw that this reference was not in the position I
expected it to be. I moved it up a few places and all, so far, seems well.

[Tom van Stiphout]

On Mon, 29 Jan 2007 20:31:01 -0000, "Deano" <de***@mailinator.com>
wrote:

Did you set the DAO object model in Tools References?
Are "prop" and "db" declared correctly?

-Tom.

>I'm really worried my db is falling apart!

I'm now getting;

"Run-time error: 13

Type mismatch"
When I run faq_DisableShiftKeyBypass in the immediate window. This is a
reference to the standard code to disable the ability to hit shift to get
into a database on start up.

It falls over at;

Set prop = db.CreateProperty("AllowByPassKey", _
dbBoolean, False)
I dug up quite an old version and it seems to be ok. Assuming there is
some sort of corruption going on how can I deal with it? I have decompiled
and compacted the database but that hasn't helped.

thanks
Martin