I created an Access database with linked tables to a SQL database.  I then
used the Security wizard putting myself in the admin group and one user in
the read-only group.  I did something wrong as this affected all of my Access
databases. 
To remove the security I followed instructions in
http://office.microsoft.com/en-us/ork2000/HA011381181033.aspx.  I also
removed the read-only user.  I was not able to import from the old database
as it said I didn't have the necessary permissions.  The original database
shows that admin is a member of users group, but not the admins group.  I am
still a member of admins, but get no prompt to log in as myself.
Before I realized this I set the admin password and then blanked it out.  It
was finally able to get into my other databases, but still not this one.  I
do have a copy of the db that I can get into.  The wizard also made a .bak
version.
The database is on a network drive.  The security.mdw is in the same folder
as the db.  There is no other version of security.mdw on the network drive,
nor on my harddrive that I can find. 
When I go to Tools, Security, the "User and Group Permission" and "User-Level
Security Wizard" are grayed out on this db, but not the other databases.
1. Is there a way to completely remove the security file and start over?
Maybe delete the security file and uninstall and reinstall Access 2003?
2. I only have 3 linked tables and 2 queries in this db, so starting over is
no problem.  I am new to Access.  Can I safely delete the Access database
without affecting the SQL tables that I linked to? Would I then rename the .
bak to .mdb and be back where I started?

Yes do that.  Also do a search for all *.mdw files on your computer; rename
each one.  Then open Access (it'll create a new clean system.mdw file) and
then open your renamed bak to mdb file.  If this works, you can then go back
and delete those mdw files you renamed.

Thank you - that did the trick

User log in
Can't Install Add-In
First time setting up security
Adding a ADDIN in Access 2007
Re: Unhiding Tools option on Menu Bar
Check if VBA Code is Disabled
HELP!
Joining MDW security group in Access 2007
Options greyed out
Security Warning