Problem with Access 2003 User Security DB opening with Access 2007

Discussion in 'Access Security' started by Donna, Apr 26, 2010.

  1. Donna

    Donna Guest

    I have a copy of a shared Access 2003 database (.mdb) which I created and
    have used since 2000 with group/user level security file (system.mdb). I
    have recently since moved to another company and want to use the database at
    this office.

    Every time I try to open it, I get the error message "You do not have the
    necessary permissions to use the ‘C:\NameOfDatabase.mdb object. Have your
    system administrator or the person who created this object establish the
    appropriate permissions for you."

    I am a little more confused now that I have read a couple of these posts
    that refer to a "System.mdw" file. I believe mine has always been
    "System.mdb".

    How can I open this database?
    I would really appreciate assistance since I spent ~ 10 years refining this
    database and would love to be able to use it again.
     
    Donna, Apr 26, 2010
    #1
    1. Advertisements

  2. You need to have the original System.mdw file (the security file, which can
    have other names, but generally has the .mdw extension) from the computer
    where the database was previously stored. If it was that easy to move a
    database around, it wouldn't be very secure, would it? You could search for
    someone one the Internet to crack your security, and there probably are
    some, but without the file, it may be expensive.
     
    Arvin Meyer [MVP], Apr 27, 2010
    #2
    1. Advertisements

  3. Donna

    Donna Guest

    I do have the original System.mdb file, but it does not have an .mdw
    extension. It contains all the groups and individual user names. Files it
    contains are MSysGroupList, MSysGroupMembers, MSysUserList and
    MSysUserMemberships.

    It was secure because of the way my opening macro was designed. Anyone who
    was not assigned to a specific group was unable to open the database. I
    removed all the permissions from the default permissions setting and moved
    them to another Group.

    How can I get Access 2007 to recognize the 2003 security settings and prompt
    me for a logon and password?

    Thanks for your help.
     
    Donna, Apr 27, 2010
    #3
  4. You can try joining the workgroup, which you will probably need to use an
    MDW file for. Just make a copy of the file you think is correct, and change
    the extension to MDW. The file you need to start it is WRKGADM.exe. Search
    for it on your machine and open it. You can even join without having Access
    open.

    If you've converted the database to an ACCDB you no longer have security,
    but I doubt that's possible unless you can log in with proper permissions.
    --
    Arvin Meyer, MCP, MVP
    http://www.datastrat.com
    http://www.accessmvp.com
    http://www.mvps.org/access
     
    Arvin Meyer [MVP], Apr 27, 2010
    #4
  5. Donna

    Donna Guest

    I have not converted it to an .accdb. Also, there is no wrkgadm.exe file on
    my current computer. It has the Office 2007 package, so I'm guessing there
    is not working group admin file in Access 2007?
     
    Donna, May 20, 2010
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.