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

Lost Administrator Rights - Can't open DBs

P: 14
Hi All,

Please could you help me. I added a new user and deleted two users on Friday using the security wizard then modified a DB. When I tried to open one of my DB this morning I was not prompted to enter user name and password as normal just DB password then an error message came up that 'I did not have the necessary permissions to use the DB and have the administrator or person who created this object set the necessary permissions for you'. I am the administrator for all my DBs (I have 5 in total). The DB are stored on a network and IT restored my DBs from previous night and this still has not worked is there any way of fixing this I have ten years worth of data in some of these DBs.

Many thanks in advance
Jan 28 '08 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,707
The most likely thing is that you've reverted to the default security file.
However, you bring in the database password like we'd been discussing it for half an hour beforehand. As we haven't, could you explain if the database had a db password set before?
Which version of Access are you using? The security file and how it's managed is an element that has changed radically between versions.
Jan 28 '08 #2

P: 14
Hi All,

Please could you help me. I added a new user and deleted two users on Friday using the security wizard then modified a DB. When I tried to open one of my DB this morning I was not prompted to enter user name and password as normal just DB password then an error message came up that 'I did not have the necessary permissions to use the DB and have the administrator or person who created this object set the necessary permissions for you'. I am the administrator for all my DBs (I have 5 in total). The DB are stored on a network and IT restored my DBs from previous night and this still has not worked is there any way of fixing this I have ten years worth of data in some of these DBs.

Many thanks in advance
Hi Sorry I thought I had explained everything OK (obviously not!).
I am using access 2003.
I implemented security using the security wizard.

I have now resolved the problem about accessing the DB I can access all the DBs but cannot establish myself as the administrator again. I have tried importing the DBs into new DBs but still unable to establish admin rights. My local IT department can't help as they do not support developement issues.

Many thanks and sorry for inconcise information
Jan 31 '08 #3

NeoPa
Expert Mod 15k+
P: 31,707
Assuming that you kept the Admin account (rather than deleting it for increased security) you can get back in as Admin by the simple expedient of changing the security database (.MDW) that your PC uses.

This will allow you in as Admin with no password. However, this will not allow you to reset passwords of (or otherwise manipulate) any other accounts, except in as much as you can recreate your previous position if you have all the information stored somewhere. I doubt you will have that information to hand unless you were very meticulous (and understood the implications fully) when you originally set it up.

I'm still a little unclear as to your current problem though.
Do you have access to your database via other accounts (thereby indicating that the correct security database is in place)? If so, surely the original Admin account would be accessible. Just a matter of knowing the password.
Do you currently just have account-free access? If so, you are not using the MDW database file you have gone to so much trouble to set up (via the Security Wizard). In fact, this scenario actually uses a non-password protected Admin account.
Jan 31 '08 #4

P: 14
Hi thanks for all your help, unfortunately I had to admit defeat and call in outside support. I was able to access the admin account but could not regain my admin rights, as you said but thankfully it retrieved all the data which was the most important thing (There is 10+ years). I did keep the security report print out but did not keep a copy of the work group file. Never again. Thanks for you help. :)
Feb 5 '08 #5

NeoPa
Expert Mod 15k+
P: 31,707
No worries.
Sorry it didn't work out as well as you'd hoped.
Feb 5 '08 #6

Post your reply

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