Prev: Help with an expression to calculate a profit from one of three fi
Next: mde file in Access 2007
From: Bob H on 30 May 2010 12:10
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/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

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
From: Arvin Meyer [MVP] on 31 May 2010 15:14
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" <bob(a)despammer.com> wrote in message
news:n5WdnQExzcYPF5_RnZ2dnUVZ8qOdnZ2d(a)giganews.com...
> 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


From: Arvin Meyer [MVP] on 31 May 2010 15:13
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" <bob(a)despammer.com> wrote in message
news:lamdnQraHOOfE5_RnZ2dnUVZ7rGdnZ2d(a)giganews.com...
> 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/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
>
> 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


First  |  Prev  | 
Pages: 1 2
Prev: Help with an expression to calculate a profit from one of three fi
Next: mde file in Access 2007