Access 2000 User security
Results 1 to 9 of 9

Thread: Access 2000 User security

  1. #1
    Senior Member
    Join Date
    Feb 2002
    Posts
    500

    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
    Ron Paul: Hope for America
    http://www.ronpaul2008.com/

  2. #2
    AOs Resident Troll
    Join Date
    Nov 2003
    Posts
    3,152
    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
    How people treat you is their karma- how you react is yours-Wayne Dyer

  3. #3
    Senior Member
    Join Date
    Feb 2002
    Posts
    500
    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!!
    Ron Paul: Hope for America
    http://www.ronpaul2008.com/

  4. #4
    AOs Resident Troll
    Join Date
    Nov 2003
    Posts
    3,152
    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
    How people treat you is their karma- how you react is yours-Wayne Dyer

  5. #5
    AO Ancient: Team Leader
    Join Date
    Oct 2002
    Posts
    5,197
    I'd with MLF on this one....

    as to:-

    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?
    Don\'t SYN us.... We\'ll SYN you.....
    \"A nation that draws too broad a difference between its scholars and its warriors will have its thinking done by cowards, and its fighting done by fools.\" - Thucydides

  6. #6
    Senior Member
    Join Date
    Feb 2002
    Posts
    500
    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...
    Ron Paul: Hope for America
    http://www.ronpaul2008.com/

  7. #7
    AO Ancient: Team Leader
    Join Date
    Oct 2002
    Posts
    5,197
    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... ). 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....
    Don\'t SYN us.... We\'ll SYN you.....
    \"A nation that draws too broad a difference between its scholars and its warriors will have its thinking done by cowards, and its fighting done by fools.\" - Thucydides

  8. #8
    AOs Resident Troll
    Join Date
    Nov 2003
    Posts
    3,152
    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
    How people treat you is their karma- how you react is yours-Wayne Dyer

  9. #9
    AO Ancient: Team Leader
    Join Date
    Oct 2002
    Posts
    5,197
    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.....
    Don\'t SYN us.... We\'ll SYN you.....
    \"A nation that draws too broad a difference between its scholars and its warriors will have its thinking done by cowards, and its fighting done by fools.\" - Thucydides

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •