How to protect my database software

M

Martin

I developed a database system by Access.

Meanwhile,
1. I don't want the users to modify any structure of the my system
2. And don't want them to find the VBA.


How to protect my database? Methods, Methods :)

Thank you.


Martin
 
A

Arvin Meyer [MVP]

Creating an MDE will keep users from modifying anything except tables and
queries. To stop that, you need to use Access User-Level security and remove
all permissions on the tables except through OwnerAccessOption queries. See
the security FAQ for specifics. Read it carefully several times, and make
sure you have backups or you will be locking yourself out of your database:

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
T

Tom Wickerath

Creating an MDE will keep users from modifying anything except tables
and queries.
Click to expand...

You can add macros to that list too.

Tom
___________________________________________
 
Top