shift key

[Cardo]

How do you enable or disable the ability to open a MS
Access database holding down the left shift button for
table access mode?
Thanks

 

[Albert D. Kallal]

You can use my sample code. It allows you to browse to the mdb of your
choice, and set, or un-set the shift key.

check out:

http://www.attcanada.net/~kallal.msn/msaccess/msaccess.html

 

[John Vinson]

How do you enable or disable the ability to open a MS
Access database holding down the left shift button for
table access mode?
Thanks

In a VBA module execute the code:

Public Sub Lockout()
Dim db As DAO.Database
Dim prp As DAO.Property
Set db = CurrentDb
On Error Resume Next
db.Properties("AllowBypassKey") = False
If Err.Number = 3270 Then
Set prp = db.CreateProperty("AllowBypassKey", dbBoolean, False)
db.Properties.Append prp
End If
End Sub

Note that you should keep a copy of the database that is not locked;
it's possible to clear this property but it's tricky.