Disabled Shift Key

13 Nov 2005 4:53 AM

felicitea

Can anyone tell me why the Shift key (to bypass startup properties) is
disabled on a database when it is running on a machine with Access 2003, but
when the database is copied to an Access 2002 machine, the Shift key is not
disabled? I'm trying to help some one (long distance) with this problem
since the person who developed the database for her is no longer available. I
can bypass the startup properties just fine on my Access 2002 machine using
the Shift key, but the Shift key seems to be disabled on hers. No where can
I find any code that has set the AllowBypassKey property to False. This is a
mdb file not an adp file. And most importantly, how do I re-enable the shift
key so that it works to bypass the startup properties on the Access 2003
machine?

Thanks.

13 Nov 2005 6:14 AM

TC

Do you save the 2003 format database in 2002 format so you have a copy
that will run with Access 2002?

If so, I'd assume that the AllowBypassKey property is not being copied
to the new (ie. 2002) database from the 2003 one. So, the property
exists & is False in your 2003 database - thus disabling the bypass key
- but it does not exist in the 2002 database - thus enabling the bypass
key.

To re-enable the bypass key in the 2003 database, I'd just log on as a
member of the Admins groups of the correct workgroup file, then execute
the following code from the Immediate (debug) window:

(untested)

dbengine(0)(0).properties.delete "allowbypasskey"

Then quit Access & try again.

HTH,
TC

13 Nov 2005 11:07 PM

felicitea

Show quote Hide quote

"TC" wrote:

> Do you save the 2003 format database in 2002 format so you have a copy
> that will run with Access 2002?
>
> If so, I'd assume that the AllowBypassKey property is not being copied
> to the new (ie. 2002) database from the 2003 one. So, the property
> exists & is False in your 2003 database - thus disabling the bypass key
> - but it does not exist in the 2002 database - thus enabling the bypass
> key.
>
> To re-enable the bypass key in the 2003 database, I'd just log on as a
> member of the Admins groups of the correct workgroup file, then execute
> the following code from the Immediate (debug) window:
>
> (untested)
>
> dbengine(0)(0).properties.delete "allowbypasskey"
>
> Then quit Access & try again.
>
> HTH,
> TC
>

I saved the ZIP file that I received as an email attachment then just
extracted the database. The Shift key was enabled on it the first time that
I opened it. After making a change in the database, saving it , and emailing
it back to the person it belongs to, the Shift key seems to be enabled on her
Access 2003 machine also. If the problem comes up again, I'll try your
solution. Thanks for responding.