Security Blunder

  • Thread starter Thread starter John M
  • Start date Start date
J

John M

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
 
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.
 
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...
 
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.
 
Back
Top