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

Removing security from Access 2002 db

P: 10
I have inherited a db at my workplace which has security on it. I would like to remove the security from it. I can logon to the database with an account that is in the admins, full permissions and users groups. It is not the admin account. Can any one help me get the security off? I want it off because I created a table that I am the owner off and out of the blue, I can no longer even open the table. When I go to group permissions and try to give myself access to this table again, it denies me saying that in order to change the permissions of the object, I must have administrator permission for it. If someone can help me get access of my table again that would be great but in the long run I think I would like to get rid of the security altogether. It is no longer necessary. Thanks in advance for any assistance.
Jan 12 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,494
Access security is a bit of a mess really.
Without knowing more, the only suggestion I can come up with is to :
  1. Rename the current security file from *.Mdw to something else.
  2. Replace the original System.Mdw if it's no longer in it's original place.
  3. Run Workgroup Admin program to reset the security file to the original (non-passworded one).
Jan 13 '07 #2

Post your reply

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