Results 1 to 3 of 3
  1. #1
    Join Date
    May 2011
    Posts
    2

    Unanswered: Locked out of my DB "You do not have the necessary permissions to use the <name> ..."

    Please help me.
    I have been developing a database for some months in Access 2003. I have put security in place (using the wizard), with the new file Security.mdw (sitting in the DB folder) working well.

    I've used it for several sessions (using the shortcut with wrkgrp \), loggin in as user "Dan" who I've set as part of all groups (user, admin, DBOwner etc).

    To get around security flaw with Access, I removed permissions from the default "admin" so sourcing the system's Security.mdw file is not going to work.

    Issue: I was setting permissions etc and changed the 'Owner' on all things to "DBOwner" group. DBOwner group has full permissions across everything. User 'Dan' is a member of DBOwner group + the other groups.

    I ran a compact & repair, and upon re-openning I received the error -
    "You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you. "

    After trying & reading forums with no success, I decided to ditch my 3hrs of work since backing up and open my backup (note - this was at the start of the session, and still required my Security.mwd via shortcut etc). However SAME MESSAGE APPEARS!

    I have no idea what to do next, and the suggestions havent worked.

    Please help, regards Dan

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try creating a new db
    then copy all the objects into the new db
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    May 2011
    Posts
    2

    Lock out of DB

    Hi, I've tried that and get the same message when I select that db file.

    I think it has something to do with changing the DB owner to a group that may not have had open/run permissions?

Tags for this Thread

Posting Permissions

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