Re: Security not clicking

Probably in your multiple attempts to set up security, you created the three
mdw files.

Access ships with a workgroup file called system.mdw that's used in every
session (even unsecured databases). It uses this one and silently logs you
in as a user called 'Admin'.

When you secure a database, you create a new workgroup file. You only need
one.

I gather from this thread that you are practising on a copy of your
database.

I suggest at this point, that you go to your backup of the unsecured mdb,
delete all the mdw files you created, and start over.

Also ensure that you don't modify the default system.mdw workgroup.

You need to follow every step outlined in securing your database or it won't
work properly.

Some resources:

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

Billy wrote:
I have tried this, not working. I have been trying to set up security
features. I set up about 3 mdw files that I have been using. Could
this be the cause of the problem?
Billy
Joan Wild wrote:
You need to log in as a member of the Admins Group - log in with that
username and you can delete/add users/groups.

--
Joan Wild
Microsoft Access MVP

Billy wrote:
I am really in some big problem here guys. Add or Remove buttons
are greyed out in the User/Accounts. What do I need to do? Got some
pressure on me here.
Billy
Billy wrote:
I followed the procedure, I am showing it is running "Enhancing
Security" but kind of stuck. Do I need to close the database or
just wait until it stops running and the green light is gone?
Thanks a lot for your help.

Rick Brandt wrote:
Billy wrote:
Do I need to delete the rest of the files that have been created
for this to be successful?

Most likely. Security learning is best done on junk files until
you are comfortable with it.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Loading