By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,478 Members | 1,665 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,478 IT Pros & Developers. It's quick & easy.

Ms Access security

P: 25
Hi guys need a help please

I just tried to apply a security level to my access database. I never used it before. and actually it's applied to all my database.

I want to remove all the security and I don't want to use it anymore, but I made a mistake by removing the admin member from my admin users, and this has made my admin user just a regular users, and I can't clear my database from this security.

How can I remedy this situation?

Thank you.
Apr 16 '09 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 15k+
P: 31,709
These settings (Users; Groups etc) are stored in the .MDW file. If you have a backup of this file then you can replace the updated one.

If not, you can try getting one from another PC with Access installed.

If none available, a standard basic one is created whenever you install Access.

This will probably only allow you to start again from scratch. All permissions are likely to need setting up again if you still want to follow that course.

As with all things, I recommend keeping backups in case of such situations.

Good luck & Welcome to Bytes!
Apr 16 '09 #2

P: 25
Thank you, I've already found that file, and deleted it, and the database is back to usual. Was this okay to do ? So far so good with no problems; I can even use my database password.
Apr 17 '09 #3

Expert Mod 15k+
P: 31,709
I don't know :S

If you'd deleted the correct file it would not be prompting you for a password at all - or even asking for a name. it would sign you in as Admin automatically with a blank password.

It does sound like the problem has gone away though.
Apr 17 '09 #4

P: 25
Yes, I think so.

Thank you guys...
Apr 20 '09 #5

Post your reply

Sign in to post your reply or Sign up for a free account.