logon under another username

[Eldon]

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?

 

[Chris O'C via AccessMonster.com]

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]

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