Access 2007 supports the MDB format which is the only format that can use
User-Level Security.
Move all the data on the server and front-end code to the MDB format (Access
2003 and earlier). Everyone will be able to use the database. FWIW, Access
2010 supports MDBs as well, and I have little doubt that it will be
supported in the next several versions.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley
"Bob H" wrote in message
...
On 30/05/2010 16:33, Arvin Meyer [MVP] wrote:
Yes, the MDB format can be secured with ULS (User-Level Security) the
ACCDB
format cannot be.
Here's all the information you will need to secure your database:
Security FAQ
http://support.microsoft.com/support...ent/secfaq.asp
Lynn Trapp's summarization:
http://www.ltcomputerdesigns.com/The10Steps.htm
KB articles:
http://support.microsoft.com/default...;en-us;q165009
http://download.microsoft.com/downlo...-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
Thanks for the links, but the situation I have is that I created the
database in Access 2007, but then saved it as a mdb file for Access 2003
users.
I then split the said database in Access 2007 on the local NAS server at
work. I copied the front end from the NAS server to local users PC's.
So do I password protect the backend as some people say, and if so how do
I do that, because some people at work have Access 2003 and others have
2007.
Thanks