Disable Access break key 1

[Alanclyde]

How can I stop people using the BREAK (shift) key to open Access in edit mode?

I have tried this in the past but failed!!!

 

[lameid]

faq181-143
faq181-1655

 

[Alanclyde]

Thanks lameid...I will try this and get back with the results.

 

[Alanclyde]

This works fine...I just need to make sure I have a backup and I remember where my hiddin button is...

 

[lameid]

Or you could just call this code with the fully qualified path and file name...

Public Sub ReEnableByPassKeyProperty(StrDBPath As String)
    Dim WS As Workspace
    Dim db As Database
    Set WS = Workspaces(0)
    Set db = WS.OpenDatabase(StrDBPath)
    db.Properties.Delete "AllowByPassKey"
    db.Properties.Refresh
End Sub

You could also only lock it before you publish it and keep a working development copy for yourself.

 

[Alanclyde]

I think I will stick with the latter option, in just activating when I publish. I have a habit of keeping several copies so I will keep it smple I think.

Once again, thanks for your help