i was trying to set a logon password in a database by using Tools-->Security-->User and Group Accounts -->Change Logon Password tab. but now i am trying to logon that database using the correct password. it says invalid password. i dont know where did i do the mistake on typing password. but how can i remove this password system and set a new password. i can't even work any other database.
First, try to enter the password using capital letters and then try with just the first letter capitalized. Passwords are case sensitive. If that doesnt work, you need to get a copy of someone elses system.mdw file. Try the caps lock first and if it doesnt work, respond to this and let me know. Heres what I will need to know.
You will need to find someone else with the same version of access as you.
What operating system is it (2000,xp,95)
What version of access is it (97,2000,xp)
I will then tell you where to get teh security file from.