Access Password Issues

[lr1234]

I'm trying to change the password to my Access Database and every time I try to set my new password it errors on "Not a Valid Password". The only difference from my old password is a change in one number. There are no special characters.

 

[Micron]

Seems straight forward. Whatever you're typing in isn't correct. Could be
- you had caps lock on and it's case sensitive
- you're not opening the same db as the one that needs the new password (it may be a copy from another folder)
- you're not typing in what you think you are or you've forgotten the new password
If the password dialog is a custom one, you might be able to get around it. If it's a password you put on the database using the Access tool, you've got a real problem.

 

[lr1234]

I'm able to open the DB just fine with the old password but when I try to create a new password I get the error. I even get the error if I try to set the new password as my old password.

 

[Micron]

Sorry, thought you were trying to get in. It seems you are in but you are trying to change the password and you are sure no special characters are being typed for the new password. In that case I'm afraid all I can do is offer links that I suppose you could find yourself. Perhaps it is related to a recent update you've made. See if this helps and note the comment about the legacy setting.

"Not a Valid Password - Runtime Error 3031" Excel ADO VBA Error Message even when password are correctly entered

VBA programming, Excel, Access, Microsoft office, VBAA2Z, Lung Pamai, UI UX, Web Scarper VBA,

vbaa2z.blogspot.com

 

[lr1234]

Thank you! Its such an odd problem. It wont even take "ABC" as the new password. Ill check out the link you provided. If that doesn't work I'm just going to create a new database and move my tables, queries, etc to the new table.

Thank you!

 

[Micron]

You're welcome, and good luck.

 

[JonXL]

Have you tried removing the password, saving, reopening and adding a password anew?