Hiding Database Window from all but Admin

[SonOfZeus]

When security the front end database for my access application, I would like to be able to ensure users are able to read/write/delete to attached tables, but not be able to go to the Database Window and run queries/edit tables directly. It's been a while since I worked with security, could anyone point me in the right direction

 

[mp9]

Check out

http://www22.brinkster.com/accessory/modules/002.shtml

for a routine to check security group membership (e.g. check whether a user is in the Admins group) and

http://www22.brinkster.com/accessory/macros/002.shtml

for a way of only enabling the F11 keystroke for members of the Admins group.