If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Password protection
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 |
#2
|
|||
|
|||
Password protection
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. |
#3
|
|||
|
|||
Password protection
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. -- 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 ... 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 |
#4
|
|||
|
|||
Password protection
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. |
#5
|
|||
|
|||
Password protection
On 30/05/2010 16:30, Arvin Meyer [MVP] wrote:
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. 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 |
#6
|
|||
|
|||
Password protection
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 |
#7
|
|||
|
|||
Password protection
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 |
#8
|
|||
|
|||
Password protection
See my response to your other post.
-- 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:30, Arvin Meyer [MVP] wrote: 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. 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 |
Thread Tools | |
Display Modes | |
|
|