N Niroshana Dec 9, 2009 #1 How to avoid unauthorized changes in the queries’ and tables’ designs of Access 2007 or 2003 databases?
How to avoid unauthorized changes in the queries’ and tables’ designs of Access 2007 or 2003 databases?
A Arvin Meyer [MVP] Dec 10, 2009 #2 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
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
