How Do You Re-enabe the Shift Key Without Access to the Immediate Window?

[Brian Smith]

Is it possible to re-enable the Shift key when you don't have access to the
Immediate Window? I have administrator permission on the database (I'm the
owner) and thought I could do this from another database that uses the exact
same Workgroup file. I disabled the Shift key using the Access Security FAQ,
Section 27. Is this possible or am I screwed?

Thanks.

Brian

 

[Jeff Conrad]

Here are two utilities that will allow you to
browse to the database file and enable/re-enable:

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

(Look for "By Pass Shift Key Code")

2. http://www.worksrite.com/

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:

 

[TC]

As well as Jeff's suggestions, you could execute the following code
from any other database, while you are logged in as a member of the
Admins group of the correct workgroup file:

(untested)

dim db as database
set db = dbengine.opendatabase("full path to other database")
on error resume next
db.properties.delete "AllowBypassKey"
on error goto 0
set db = nothing

HTH,
TC

 

[Brian Smith]

As well as Jeff's suggestions, you could execute the following code
from any other database, while you are logged in as a member of the
Admins group of the correct workgroup file:

(untested)

dim db as database
set db = dbengine.opendatabase("full path to other database")
on error resume next
db.properties.delete "AllowBypassKey"
on error goto 0
set db = nothing

HTH,
TC

Albert Kallal's utility did the job perfectly. However, it does lead to a
few questions. Could anyone use such a utility to turn the bypass key back
on or do they need to have administrative privileges on the database?

Thanks.

Brian

 

[TC]

It depends on how the AllowBypassKey property was added to the database
in question.

If it was added using the CreateProperty method /and/ the 4th(?) or
"DDL" parameter of that call was set to True, you can only change the
value of the property if you are a member of the Admins group of the
workgroup file which was in effect when the database was first created.

If you did not create it that way then anyone can change its value.

HTH,
TC

 

[Brian Smith]

It depends on how the AllowBypassKey property was added to the database
in question.

If it was added using the CreateProperty method /and/ the 4th(?) or
"DDL" parameter of that call was set to True, you can only change the
value of the property if you are a member of the Admins group of the
workgroup file which was in effect when the database was first created.

If you did not create it that way then anyone can change its value.

HTH,
TC

I followed the Security FAQ exactly and did set the fourth parameter to
True. So I'm glad to hear that non-admin users can't change this setting.

Thanks for the info TC.

Brian