Results 1 to 3 of 3
  1. #1
    Join Date
    May 2013
    Posts
    32

    Unanswered: Urgent Help Needed!!!!



    I used the MS Access security wizard and it quickly became apparent I didn't know what I was doing. I stopped it and reverted back to how it was. I then spent the next few days populating tables and doing work on it. Finally finished the whole database off so I saved and closed it. However because of the security wizard there is no access at all to my database.

    There are 2 users like there were before, users and admin... Both have no access, not even read access so I can't see my database, the back up file only has the data pre wizard so it's useless and has lost about 5 days of work.

    Is there anyway at all I can export the tables without any read rights?

    Can I somehow tell the database its being silly and that no one has access to it and maybe it can correct it?

    Is there a script I can run to either export the table or give full rights to myself temporarily? Long enough to copy the tables and modules to the back up?

    I really need help with this, I don't want to tell my boss I did work for 5 days and have to do it again for 5 days

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183
    If you are using the default System.mdw database as your workgroup information file then try re-installing Microsoft Access.
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

  3. #3
    Join Date
    Nov 2011
    Posts
    413

Posting Permissions

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