Application Security

Alan Bartoli · Feb 18, 2004

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 · Feb 18, 2004

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.

Application Security

Alan Bartoli

Joan Wild