Re: Security Blunder

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

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 06/19/04 

Date: Sat, 19 Jun 2004 10:09:06 -0400

Check the folder where your mdb is. The security wizard usually creates an
unsecure backup of your file (unless you declined the opportunity). It will
have the same name as your mdb, but a bak extension. Rename it back to mdb.

Then use the workgroup administrator to rejoin the standard system.mdw
workgroup that ships with Access. 

-- 
Joan Wild
Microsoft Access MVP
John M wrote:
> That part of it is fine It does come up with the login
> section for the workgroup however the user names and
> passwords I setup dont work...
>> -----Original Message-----
>> Access security involves two parts: some of the
> information is stored in the
>> MDB itself. but part is stored in a workgroup file (.MDW). I suspect
>> that you're not opening the databases with the appropriate MDW file.
>> You can either specify the MDW file in a short cut pointing to the
>> database:
>>
>> <full path to msaccess.exe> <full path to MDB> /wrkgrp <full path to
>> MDW>
>>
>> or you can use WRKGADM.EXE to "join" the appropriate workgroup file.
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (No private e-mails, please)
>>
>>
>> "John M" <anonymous@discussions.microsoft.com> wrote in message
>> news:1d3ed01c4536b$85659690$a001280a@phx.gbl...
>>> Hi, I have screwed all of my databases on my system by
>>> playing with the security wizard I setup some user groups
>>> to see what could be done with it now i can not open any
>>> database on my system...All I get is the logon window with
>>> the request for user name and password ..I printed the
>>> "One-Step Security Wizard Report" so that I could undo any
>>> changes I made but it will not let me into any database
>>> even using the user names and passwords as listed on the
>>> report.
>>>
>>> Any ideas on what I can do as I have 70 - 90 hours of work
>>> here I really dont want to do over again..
>>>
>>> Many Thanks
>>>
>>>
>>
>>
>> .

Relevant Pages

  • Re: Export to de-secure
    ... > dropping settings in the workgroup administrator, ... > security features transfer to the new database, ... this new mdb is unsecured. ... Quit Access, and open your secure 97 mdb, logging in as a member ...
    (microsoft.public.access.security)
  • Re: no login prompt
    ... The login prompt fires if, and only if, the Admin user of the workgroup you ... to secure the database, then you will not get a prompt. ... The Security Wizard ...
    (microsoft.public.access.security)
  • Re: Open/Run
    ... permissions but if I created a new database using that workgroup all the ... database with the workgroup I assumed they are part of the workgroup. ... The Workgroup file contains Groups, UserAccounts, and the information about ... All that the MDB cares about is... ...
    (microsoft.public.access.security)
  • Re: Locked Out
    ... > I was playing with the security wizards on a database I would like to ... Now I cannot get into any database. ... That indicates that the workgroup you created to secure the mdb is now your ...
    (microsoft.public.access.security)
  • Re: Define workgroup on activate event?
    ... > I would like to know if it is possible for an .mdb database to define ... > its workgroup when it opens. ... > with the /wrkgrp flag pointing at my workgroup file, ...
    (microsoft.public.access.security)