HELP! Secure file, cannot access!

[MrMMM]

I implemented Access security and created a few users. Everything was
working fine for quite a while. Today, I accidentally clicked on "clear
password" for the admin user. Now, when I try to start the application,
it says I do not have the permission to open it (it doesn't even
present the user/pw dialog).
I know I did something wrong. What can I do to fix this???

Thank you.

 

[Arvin Meyer [MVP]]

Make sure that you have the correct security file (it will have the .mdw
extension) BTW, when you bring up security dialogs, if you are not an admin,
you cannot clear a password, only change your own. If you are an admin, and
clear your own password, you will not have one.

 

[MrMMM]

Well, I was a user with admin right. So I accidentally cliced on "clear
password" with the Admin user selected. Now when I try to open the
file, it says that I do not have premission. The secure file specified
is correct, since I've been using it for almost a year. Nothing really
changed, besides the fact that I clicked "clear password" and then
closed the file.

 

[MrMMM]

Ok, I was just being an idiot.
When I cleared the Admin password, it was a signal to Access to stop
asking for the uname/password. And since my Admin user was not really
and admin, and had no right in the app, it could not open it. All I had
to do was create a blank database, join it to the existing secured
workgroup for the Applicaiton, and change the admin password. When I
open my app now, it asks for the password and life is good again.