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
--
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 29/05/2010 23:56, Bob H wrote:
I have a database on a local server at work, and there are copies of the
front end on several local computers.
I now want to password protect the database and restrict data editing to
just 2 users.

How do I go about this.
Thanks

This database is an Access 2003 format, mdb file, and I notice that in
database tools in Access 2007, the option is Users and Permissions, rather
than encryption which is shown in a accees 2007 file.