I have converted a 2003 db to 2007, and stripped the user-level security out
of it by making all items have the lowest seciruty level, and managed to
allow logons thru the .mdw (db is still .mdb format) without users having to
go through a 'logon' procedure anymore.  Now, I need to re-institute
user-level security again, and am having problems.  Whenever I logon, I am
'Admin', and the database is owned by me, under my initials as the owner, not
Admin.  I need a way to logon again under my initials, not Admin.  Any help
out there, please?

Give the admin user a password.  Next time you try to open a db with the
secure workgroup, you'll be prompted for user name and password.  Change
"Admin" to the db owner's name, give the password and you're in.

Chris


Eldon wrote:

That simple answer is what I needed, Thank you Chris.
Show quoteHide quote

IGNORE SECURITY!
By Pass Password
Access 2007 -> /pwd -> how to work around?
Establishing a Password for a Delete Button
user-level security and splitting database
One-Step Security Wizard wont open file
Access 2007 "compact and repair" asking password
Error 2950 - Related to Trust Center?
User locked out
Logout/login w/o closing Access