Can Not Secure a A2000 Database

From: Michael Thompson (michael.thompson_at_summitmg.com)
Date: 09/01/04 

Date: 1 Sep 2004 09:02:02 -0700

I have a A2000 database on the server which I can secure if I open
from my PC with or without the shortcut, but any other user can open
the database with full authority using their default mdw file.

I have re-re-re done the Security steps from the Microsoft FAQ, a
couple of books and still can not get a sucure database. I have even
gotten others involved and we went through the steps, step by step and
even that does not seem to work.

The Admin user
- has a password,
- doesn't own the database,
- doesn't own any object in it,
- doesn't have any permissions to any object, including the database.
- doesn't belong to Admins group,
- doesn't belong to any other group except Users which also owns
nothing and has no permissions whatsoever.

I can not get the User Security Wizard to complete when building a new
mdw file. It gives the error "An Unexpected Error occured while
creating the workgroup file. The wizard can't complete successfully."
and ends.

To create the mdw file I have used the wrkgadm.exe. I then used it to
join the workgroup, then applied the security manually.

How do I secure the database?

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: MDE
    ... - You are using the incorrect MDW file used to secure the database. ... MDE open or not) select teh menu option Tools> Security> User and Group ... if you don't see the other User Accounts you created when the ...
    (microsoft.public.access.security)
  • Re: access 2003
    ... security in access 2003. ... The data will go on the server and the program database ... than the alternative of creating an mde file. ... MDW file from the written record. ...
    (microsoft.public.access.conversion)
  • Re: Securing data
    ... Access provides User Level Security, which is the most secure method ... Why would each staff member have their own database? ...
    (microsoft.public.access.security)