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

  • Thread starter Thread starter Brian Smith
  • Start date Start date
B

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
 
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
 
TC said:
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
Click to expand...

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
 
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
 
TC said:
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
Click to expand...

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
 
Back
Top