A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Password protection



 
 
Thread Tools Display Modes
  #1  
Old May 29th, 2010, 11:56 PM posted to microsoft.public.access.forms
Bob H[_4_]
external usenet poster
 
Posts: 161
Default 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  
Old May 30th, 2010, 12:31 AM posted to microsoft.public.access.forms
Bob H[_4_]
external usenet poster
 
Posts: 161
Default 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  
Old May 30th, 2010, 04:30 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default 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  
Old May 30th, 2010, 04:33 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default 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  
Old May 30th, 2010, 04:55 PM posted to microsoft.public.access.forms
Bob H[_4_]
external usenet poster
 
Posts: 161
Default 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  
Old May 30th, 2010, 05:10 PM posted to microsoft.public.access.forms
Bob H[_4_]
external usenet poster
 
Posts: 161
Default 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  
Old May 31st, 2010, 08:13 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default 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  
Old May 31st, 2010, 08:14 PM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:23 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.