security of Tables & Queries

[Niroshana]

How to avoid unauthorized changes in the queries’ and tables’ designs of
Access 2007 or 2003 databases?

 

[Arvin Meyer [MVP]]

With 2003, you can use User Level Security. There is no such protection in
2007, unless you use the MDB format. Have a look at the following security
information:

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

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

KB articles:
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

Joan Wild's articles:
http://www.jmwild.com/security02.htm
http://www.jmwild.com/security97.htm
http://www.jmwild.com/SecureNoLogin.htm
http://www.jmwild.com/Unsecure.htm