Linda said:
When I go to Tools, then Security and Select Workgroup Administrator, my
name
appears.
That dialog just tells you the default workgroup file (mdw), not a username.
When I look in permissions, I see lnichols and that Users is
The Users Group is common to all mdw files, so normally doesn't have any
permissions. If you have a properly secured mdb, then there should be other
groups (besides Admins and Users). It sounds as though someone just went in
and started added usernames to the standard mdw that ships with Access. In
other words, it isn't secured at all. Are there any other Groups and/or
Users when you look at Tools, Security, Accounts?
Try hitting Ctrl-G and typing
?dbEngine.SystemDB
What is the path/filename returned by that?
I appear to have all rights, as does Admin, except for open/run.
General User only has Read Design and Read Data permission.
Do I already have security and don't see it?
I don't think you do. If you start Access and create a new mdb, can you
then use File, Get External Data and import all the objects from your mdb?
If so, then no, you had/have no security.
To learn more...
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