Application Security

[Alan Bartoli]

Hi,

I am developing a system that generates reports. How can I
disallow users to view the tables, queries and also code.
I know about the startup option of Access but if they
press Shift + Enter on the application they can browse
edit and do whatever they want with the database.What is
the solution?

Hope to hear from anyone soon..

Regards and thanks

Alan Bartoli

 

[Joan Wild]

You can disable the shiftkey bypass. See
http://www.mvps.org/access/modules/mdl0011.htm
and
http://www.mvps.org/access/general/gen0040.htm

Also you can create a MDE file. That will hide the design of forms/reports
and code, however not tables/queries. If you do this, be sure to keep a
copy of your mdb file as that is the only place you can make changes.