Actually, you can prevent uses from seeing any of the database design items.
And, you can prevent the users from seeing any of the built-in ms-access
interface. Further, you can do all of this without any code, and further,
you don't need any security to do this.
All of user options you need to set to accomplish the above can be found in
the tools->startup.
You of course do need to distribute a mde to your users..but likely you
always done that anyway.
If you want to download a "test" application were all of the ms-access stuff
is hidden, then grab the 3rd download here, and run it:
http://www.members.shaw.ca/AlbertKallal/msaccess/DownLoad.htm
The only two steps in the above missing is to convert the application to a
mde (this means even if they do get inside the application..they still can't
modify forms etc). And, you could also dis-able the shift key by-pass. I
have a utility that lets you set that here:
http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html
