RE: security wizard cannot be run



It sounds like you didn't remove security properly.

Join the standard system.mdw workgroup file; create a new mdb and import all
objects from your mdb.

If that succeeds, then you can run the wizard, however I recommend that you
study up on security, and practice on a copy of your database until you are
confident.

Security FAQ
http://support.microsoft.com/?id=207793

Security Whitepaper
http://support.microsoft.com/?id=148555

Although the whitepaper is old, it contains information to help you
understand security.

I've also outlined the detailed steps at
www.jmwild.com/AccessSecurity.htm
--
Joan Wild
Microsoft Access MVP


"Desperate!!" wrote:

I'm desperate - again!

I have a database that I have been working on for some time. I applied user
level security (my first ever effort) and found it to be a nightmare. Because
the database needed further development, I removed the security. Can't
remember exactly how as it was a trial and error method (5 million trials,
4,999,999 errors!!!). I further developed the app and now the time has come
to re-apply the security, but I get the error message "The security wizard
cannot be run on a database when you are both logged on as the Admin user and
the wizard has previously run on this database". Can't start the wizard.
Can't apply database password.

I managed to join to the original secure workgroup file and I now have some
level of access to the security features, but still cant set a database
password or get teh database to request a password for any of the users.

Any suggestions?
.



Relevant Pages

  • Re: How to remove password dialog?
    ... around with Access security anymore. ... Don't run the wizard. ... >wizard to secure your ... >> database. ...
    (microsoft.public.access.security)
  • Re: Use Level Security lockout
    ... MDW to open your database with some specialized permissions. ... see if I could use it to open the MDB with the correct credentials. ... Here are a number of links about security: ...
    (microsoft.public.access.security)
  • Re: Used security wizard but no logon prompt?
    ... Don't use the Security Wizard in Access 2K. ... You are still joined to the default workgroup, not your secure workgroup. ... only when opening the secured database. ...
    (microsoft.public.access.security)
  • Re: ARRGGHHHH!! Cant open my database now!
    ... The wizard may have created an unsecured backup of your mdb (it'll have a bak extension). ... In addition, you may have to go into Tools, Security, Workgroup Administrator and ensure that your current default is set to system.mdw. ...
    (microsoft.public.access.security)
  • Re: locked out
    ... Access 2000 doesn't have Tools, security, workgroup administrator, so are ... Check in the folder where the mdb is located. ... the mdb that the wizard created before it secured your database. ... should know that the wizard is flawed; you'd need to secure it manually. ...
    (microsoft.public.access.security)

Loading