Re: Securing data

Tech-Archive recommends: Fix windows errors by optimizing your registry

Access provides User Level Security (ULS), which is the most secure method
you can use with Access. Combined with OS security, it's about as good as
you can get with Access. However, in order for a user to use an Access
database, they must have read/write/create/delete perms on the directory
housing the backend, so they could definitely copy it. Implementing ULS
would just make it more difficult to do much with the file in the event they
did copy it. If your client wants a more secure platform, they could move to
a server type engine like MS Sql Server, Oracle, MySQL etc etc

Here's the Access Security FAQ:

http://support.microsoft.com/default.aspx?scid=%2Fsupport%2Faccess%2Fcontent%2Fsecfaq.asp

There are also several other resources available ... Joan Wild's page has
links to most of them:

http://www.jmwild.com/Accesssecurity.htm

Why would each staff member have their own database? That sounds like a
maintenance nightmare ... could they not share a database?

--
Scott McDaniel
InfoTrakker Software

"Steve Bu" <steve@xxxxxxxxxxxxx> wrote in message
news:uC%23s8%230pFHA.2240@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I have a client whose requirement is for a database for each of his sales
> staff.
> He wanted the Front-end for each Access (2000) db to be on a the sales
> staff
> local p.c.with the respective db's to be on the office administrator's
> p.c.
> (acting as a server) on a local network. He is now concerned that the
> database(s) could be copied and is asking if there is any way to secure
> the
> individual databases whilst still allowing access by staff and the
> printing
> of individual records.
>
> Thanks......
>
>


.

Relevant Pages

  • Re: How to remove password dialog?
    ... I'd like to have no security setting at ... Backup your secure database ... >then open that bak file you renamed. ...
    (microsoft.public.access.security)
  • Re: Prevent copying to local HD
    ... probably confused issues by stating a database example. ... > security breach. ... We do have Citrix Metaframe. ... Even the passwords are not entirely secure ...
    (microsoft.public.windows.server.security)
  • Re: locked out
    ... Access 2000 doesn't have Tools, security, workgroup administrator, so are ... Check in the folder where the mdb is located. ... the mdb that the wizard created before it secured your database. ... should know that the wizard is flawed; you'd need to secure it manually. ...
    (microsoft.public.access.security)
  • RE: Security of Password-Managers
    ... Another way that you could keep yourself secure is to group passwords into ... Personally, I don't like to keep everything in one database, it may seem ... 1024 should be hard to crack security. ... >By the way, your English is fine. ...
    (Security-Basics)
  • Re: Moving from Defense to Offense (or vice versa) to secure your network
    ... frequently those who've qualified with security certs too). ... refused to make any changes to the database server (where the changes ... The net result for the business here was that they required alterations ... the staff member employed to manage the infrastructure wouldn't touch ...
    (Pen-Test)