How do I set up a Database so users cannot change tables,forms,rep

[Guest]

I have created a Constituents Database. I have it in various offices without
any restrictions on users. I would like to set up the database so that users
cannot access tables, forms or reports other than what I have set up without
my permission. What is the easiest and best way to accomplish this?

 

[Arvin Meyer [MVP]]

Set up user-level security and deny permissions on the tables except through
WITHOWNERACCESSOPTION queries. Use those queries as the record source on
forms and reports. Carefully read the Access security FAQ for all the
details. Here is a list of great security resources:

Security FAQ
http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm

http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
http://download.microsoft.com/download/access97/faq1/1/win98/en-us/secfaq.exe
http://support.microsoft.com/default.aspx?kbid=325261

http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm

--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Larry Daugherty]

There are a host of implications in your question and not much
information in your post to help us make targeted responses. If you
post back, include more information about the shape and performance of
your application and what are the real-world issues involved.

You should consider splitting your design into Front End (with
everything but the tables) and Back End (which has only the tables)
That way if ever the impossible occurs you could correct a design
issue or enhance your user interface without having to be concerned
about protecting your users' data.

The next thing you should consider is delivering your application in
the form of an MDE. That very effectively protects your Front End
from design alterations.

If you have done the above and are concerned that malicious entities
are getting into the Back End to alter data or change the design, post
back with those separate issues.

HTH