Question Getting rid of password's on opening all database's

[mayestom]

I was exploring using User-level permissions on databases so I, the admin, can have full permissions to edit/change etc. the database and certain users can only add/edit data. But I inadvertently have now set Access to ask me for a password for any db I open. Even if it's my own personal one. Can I set up Access to only ask for login info on certain db's, not all.
I know that 2010 did away with User and group level permissions but was able to add it back through customizing the ribbon and adding this feature back to it.
Thank you for any time spent on this.
Using: Win 7, Access 2010.

 

[burrina]

Do you not have password access security level in place via your code? In any case, go into your Access settings and change it back. I don't think you can do what you are asking, but then i have been wrong before!

 

[mayestom]

burrina - I'm not sure what 'code' you are talking about? Also, I don't know how to change it back so I don't get asked for a password.

 

[burrina]

Go To File Set Database Password for Access 2010 and Unset it.

 

[mayestom]

Go To File Set Database Password for Access 2010 and Unset it.

I'm sorry I'm relatively new to Access, you need to be more specific as to where I find this option to unset it.

 

[burrina]

Open the db by holding down the shift key, click on File, then Set Database Password and Unset it.
You could not have done this by accident and forgot how you did it?
Even if we are not on the same page and it is a form password?


Very Strange!

 

[mayestom]

That's not how I set the password to begin with. I set it by adding the Users and Permissions button on the ribbon and clicking on User groups and accounts. But there is no option in there to "unset" it. Only an option to change it.
I also trying holding the shift key and opening the db but that does nothing. It opens the same way by asking me for my password.

 

[burrina]

If you change it, change it to nothing and it won't ask for a password.

 

[mayestom]

That worked! I went to the change password option put in my old password and in the space where it asks for the new password I put nothing. The next time I opened the db it didn't ask for my password!

Thank you burrina for your time in helping me with this. I appreciate it.

 

[burrina]

Your Very Welcome, Good Luck With Your Project.