Access Security

[garyd1234]

Hi,
I have a secure database .mdb that has some groups and users set up. When I log in as the lowest user (least permissions), they can still hit Alt F11 and go into the code window. They can change something but it won't let them save it. First of all, does anyone know why it even lets a user like that into the code window and can I stop it- diable the Alt F11 keys. Secondly, at times if the user did go into the code window, try to change something then close the code window and try to exit the app normally with the X or with my Exit button, it gives an Onclick event error and a series of messages saying you don't have exclusive access to the db and won't let the user leave the app. Any ideas why and how to fix it? Thanks

 

[dk]

Hi,

Try this out:-

First, run this code in your database:-

Sub AddProp()
Dim prop As DAO.Property

Set prop = CurrentDb.CreateProperty("allowbypasskey", dbBoolean, False)
CurrentDb.Properties.Append prop

End Sub

You only need to run it once, you can delete it after you've run it.

Secondly, go into Tools, Startup and untick the Show Database Window and Use Access Special Keys (and probably the menu as well).

Go into the VB editor and run this:-

Sub Dis()
CurrentDb.Properties("allowbypasskey") = False
End Sub


I think that's it. If it doesn't work as expected then please post back.