security wizard not working

[TImothy]

Ive been trying to secure a database. I can create a
workgrp, assign users and permissions. When I use the
security wizard to do it all, I dont see where the Admin
is asked for a password (assignes one automatically and I
find it on the info sheet) and it says I need permission
from the owner to do things. I am the owner of the blank
database, but It doesnt let me go in to change things. I
also am unable to delete the Admin user and users group.
Am I doing something wrong or is access 2002 messed up?
any and all help will be greatly appreciated.

Timothy

 

[Scott McDaniel]

Not sure exactly what you're doing wrong, but I would encourage you to
download and read-read-read the MS Security FAQs
(http://support.microsoft.com/default.aspx?scid=/support/access/conten
t%2Fsecfaq.asp). Follow EACH step carefully, don't leave any out, and you
will properly secure your database.

You cannot delete the Users group nor remove the Admin user, and all Users
are joined to the Users group immediately (and you cannot remove them from
the Users group). You must remove ALL permissions from the Users group
except for those permissions you wish ALL users to ALWAYS have ... however,
most developers remove all permissions from the users group and build custom
groups.