Security Wizard Problem

[Sharkbyte]

I wasn't able to find my answer in the history, so my apologies if I'm asking
a repeat question...

I have someone who has created their own db (2003), and they ran the
Security Wizard, to provide workgroups and login/passwords. This works fine
except that now any database a non-Admin user opens, requires the same
login/password.

Is there a flag, that was missed, that caused Access to apply the security
to all dbs rather than just the one? How might we set the security to only
the necessary db?

Thanks in advance.

Sharkbyte

 

[BruceM]

First, locate a file named System.mdw (it will probably be in
{Username}\Application Data\Microsoft\Access). Next, in Access go to Toolsname of the workgroup to which you are joined. If it is not System.mdw,
click the Join button and navigate to System.mdw.

If the workgroup listed is System.mdw, go to Tools >> Security >> User and
group accounts. Clear the password for the Admin user, close the database,
and try opening it again. If no luck, close Access. Rename System.mdw
(call it System.OLD or some such), then open Access. Access should create a
new System.mdw file that does not have any apparent security restrictions.

For more, see here:
http://www.geocities.com/jacksonmacd/

I found Jack MacDonald's paper to be especially helpful, but all of the
links are worth checking out. Study User Level Security carefully before
trying to implement it. It is rather elaborate to set up.

Essentially, User Level Security is in place all the time, but with such
generous permissions that a default user has full rights to everything in
the database. I do not use the wizard, so I don't know where it led you,
but you should be able to back up and start over by one means or another.