How to protect my database software

[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

 

[Douglas J. Steele]

Try converting to an MDE. That will definitely keep them out of the VBA.

 

[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

 

[Guest]

Creating an MDE will keep users from modifying anything except tables

and queries.

You can add macros to that list too.

Tom
___________________________________________