Access not asking for login

['69 Camaro]

You're welcome! Glad it helped.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Guest]

I tried to remove the security as discussed in multiple threads here and must
have jacked it up. My username account is still there, but when I open the
database, it no longer asks for a login. It just opens up, but now I can't
change anything because it defaults to the Admin user. PLEASE HELP!!!

 

[Guest]

Worked GREAT! Thanks, Gunny!

Hi.


Good. As the Admin user, you can assign a new passord to your user account.
And you know that when the Admin user has a password, _everyone_ joined to
that workgroup will be prompted to supply a user ID and password.

So, just give the Admin user a password, close the Access database, then
open it again, and you'll be prompted for a user ID and password. Log in as
the owner of the database and make your changes.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.