Restricting Table Access

[JordanR]

I've read everything I can get my hands on about securing a database, and I think I have it all implemented the way I want, but my users can still do one thing I don't want.
It seems really simple, but I can't find a way to stop my users from accessing a table from the database window. They should be able to add records, update records, etc. But only from the forms I've supplied, since the forms have adequite audit reporting built in.
Any way to programatically say
On database load
If user isn't me then
Don't permit F11 or anything else that allows a user to bring up the database window.
Else
Behave normally

 

[ghudson]

I load an AutoKeys macro to override the F keys functions. The only two macros a db could/should have are AutoExec and AutoKeys. Access Help will give you more details.

You can turn off the "Use Access Special Keys' function in the Startup options.

I also use the /Runtime command in my custom shortcut. Access 2003 will allow you to do this even though the user has not installed the runtime version of Access 2003 as long as the user has the retail version of Access 2003 installed.

You should also disable to Shift key.

All of the above has been covered in numerous threads.