Re: Can Not Secure a A2000 Database

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

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 09/01/04


Date: Wed, 1 Sep 2004 17:27:48 -0400

You shouldn't use the security wizard in 2000. You can try following the
steps I've outlined at
 www.jmwild.com/AccessSecurity.htm

Michael Thompson wrote:
> 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?

-- 
Joan Wild
Microsoft Access MVP


Relevant Pages

  • RE: SetValue and CurrentUser()
    ... Currentuser is a built-in access function that refers to the user currently ... login into the database using a workgroup file (mdw file), ...
    (microsoft.public.access.macros)
  • Re: Odd (Japanese/Chinese) characters in my security dialogs
    ... because it is set up as the Workgroup file. ... I tried to copy the database into another database and the dialog ... I have tried the repair option. ... and navigate to the .mdw file. ...
    (microsoft.public.access.gettingstarted)
  • Re: Default .mdw
    ... Just get them to start the secured database using a shortcut of the ... That approach does not redefine the default workgroup file. ... When I create the new .mdw file, ... > there system reverts to there system default .mdw? ...
    (microsoft.public.access.security)
  • Re: DB locked - what have I done?
    ... >> some kind of fatal error, that Access made a backup file? ... When such an error occurs in your version of Access, a backup of the ... > database, neither of which you recall seeing. ... The Security Wizard prompts the user ...
    (microsoft.public.access.security)
  • Re: You do not have the necessary permissions to use the object. Have your sy
    ... security wizard went to work on it. ... You need the secure workgroup file to open your secure db. ... middle i have installed access 2003 and continue working with my database. ... message appears You do not have the necessary permissions to use the ...
    (microsoft.public.access.security)