Password protection

B

Bob H

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
 
B

Bob H

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
Click to expand...

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.
 
A

Arvin Meyer [MVP]

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/access/content/secfaq.asp

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
--
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
 
B

Bob H

I would use the server to protect the data. Move the back-end on the server
to a folder which is accessible only to those you want.
Click to expand...

The backend is already on a NAS server, and I have read on various
sites/forums that the backend should be password protected, but I can't
find out how to do that.
Some people say that they have done it, but not how.

Thanks
 
B

Bob H

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/access/content/secfaq.asp

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
Click to expand...

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
 
A

Arvin Meyer [MVP]

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
 
Top