Access 2000 User security

We have an Access 2000 MDB file. Apparently one of the users decided to play techie and added all the users to all the groups in access (this is MSAccess security settings NOT windows/folder security). He then removed Admin from the admin group. All the users are in all groups, this includes read only and such. Now no one can open the database. I have the database here in the techroom, along with the Secured.mdw (which is where i saw these user settings). Is there any way to access the database (clear the security settings) or at least put admin back into the admin group (admin is in users only right now).

The error message i get upon opening is:
You do not have the necessary permissions to use the database.mdb object. Have your system administrator or the person who created this object establish the appropriate permissions for you

FROM the MS website




SUMMARY
Microsoft has added database passwords, security account passwords, and Visual Basic for Applications (VBA) passwords to Microsoft Access so that you can prevent unauthorized access to important information. If you are unable to access database information because you do not know the correct password, please realize that:
MICROSOFT SUPPORT PROFESSIONALS CANNOT ASSIST, UNDER ANY CIRCUMSTANCES, IN THE BREAKING OF PASSWORDS APPLIED TO FILES AND FEATURES WITHIN MICROSOFT PROGRAMS.
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
189126 Microsoft's Policy Regarding Missing or Invalid Passwords


Got a backup????

MLF

its an unsecured database, no password. Just the user seucirty settings got screwed up. I can't imagine how access allows Admin to be removed from the Admin group!!

heres a link to the FAQ on Access security...

you may be able to gleen someway to fix it.

http://support.microsoft.com/?scid=h...t%2fsecfaq.asp

May be worth the $245.00 for a call to MS..seeing it is not a password issue. They may not tell you how to do it..but have you send them the DB and fix it for you and send back.

I have received support like this from them on another MS Business application..

I guess it all depends on how important that db is...

I backup the data here every night.....for this very reason.

MLF

I'd with MLF on this one....

as to:-

Quote:

---

Apparently one of the users decided to play techie

---

Considering _what_ was done I wouldn't consider this to be "playing techie", I would consider it to be a malicious act and the (L)user would be disciplined. OTOH, since security was implemented on the database why did you allow a (L)user the ability to alter the security in the first place?

It was a database they made and maintaned, we play no part in that. I guess he thought it would be cool if only they could access it, and tried to impliment some security. It was just a plain old database with no security anything, because its really useless inventory. They just come to me when things dont work, lol. I just thought this should be easy, since its not password protected or encrypted, there should be a way to just dump the data, or read it with a diff program... I guess microsoft doesn't like people making things like that though...

Cross:

ROFLMAO.... It was their toy. they broke it..... Their problem....

I went through **** with users making their own databases and then, when it has a gig or so of data neatly separated into 5 different databases separated by year with new fields added and old fields renamed and 15 instances of "Last Seen Date" or something similar they would come to me asking me to consolidate it all into one thing and write a proper interface to access it and report from it..... I did it twice, (3-6 months of massaging data and testing it... :rolleyes:). At that point I made a simple edict.... If users create databases without the initial involvement of the IT department then it immediately becomes their responsibility to manage and maintain, the IT department will only advise them of their options.... It's funny, The IT department has created the database structure for every database since... life has been so much easier.

Might I suggest you tell them the same.... ;)

Maybe you can import the tables\queries etc into a new db

or use a crystal report to get the data???

Can you access the data from another access db or a tool like crystal??

Just thoughts

MLF

MLF:

IIRC, he will get an access denied if he tried to import or link the tables from another instance of Access but it is definitely worth a try... Prolly shoulda thought of that myself but I was too busy giggling about the concept of taking the admin out of the admin group..... :rolleyes: