Re: Protecting an Access Database

On Wed, 8 Aug 2007 02:35:21 -0700, JonathanLewin <JonathanLewin@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I have built an Access database a while ago and I have gained a lot of
interest in the database. I now need to protect it so no one can change any
of the data or applications within it i.e. make it equivalent to a read only
file or database some how. I have hidden the database window so only the
display screen an menu options can be accessed but this does not stop people
from un hiding the database window and changing the data, tables, queries,
forms, reports etc.

How do I make it so people can open the database and use it but can not
actually go in to it and change ANYTHING!?

Deploying your database in the .mde format will stop users from being able to view or change Forms, Reports, or Modules.

To protect Tables and Queries, you'll need to implement User Level SEcurity. See Joan Wild's site for detailed
step-by-step instructions for doing this;

www.jmwild.com

You will also want to move all data access to RWOP (Run With Owner Permission) queries so that you can remove
permissions directly from the table for users. Again, see Joan's site for info on this.

Also be aware that ULS is easily breakable for those who wish to purhcase a password unlocker.


Any suggestions would be appreciated.

Thank you
Jonathan

Scott McDaniel
scott@xxxxxxxxxxxxxxxxxxxxxxxxx
www.infotrakker.com
.

Relevant Pages

  • Re: Protecting an Access Database
    ... To protect Tables and Queries, you'll need to implement User Level ... Any ideas on what to do to better protect the database after using ULS? ... If you need better data security, you'll need to move to a ...
    (microsoft.public.access.security)
  • Re: database password and encryption
    ... I know the basic concepts about encryption. ... This database should be encrypted with a strong, ... way you can protect the database AT ALL. ... I could encrypt the key several times and hide the new, resulting, keys on ...
    (microsoft.public.platformsdk.security)
  • Re: Protecting an Access Database
    ... To protect Tables and Queries, you'll need to implement User Level ... a password unlocker. ... Any ideas on what to do to better protect the database after using ULS? ...
    (microsoft.public.access.security)
  • Re: Securing tables in MDE
    ... how do you protect the BE? ... >Hi Kevin ... >queries, forms, reports, macros & mopdules, and links to ... >Atoring everything in a single database, ...
    (microsoft.public.access.security)
  • Re: password-copyright
    ... it's basically the same exact mechanism as a login ... verify one item, such as a keyword, phrase, or password. ... database and if it is, you set a cookie saying they are authenticated. ... trying to protect your work or some similar profession, ...
    (microsoft.public.frontpage.client)