Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2008
    Posts
    2

    Unanswered: Permission problem when going from Access97 to Access2007

    Hi,

    I'm trying to convert several hundred Access97 MDBs to Access2007, but I keep getting the same error when I open the MDBs in Access2007:
    The current user account doesn't have permission to convert or enable this database.

    Screenshot with similar issue:
    http://www.dbforums.com/attachment.p...2&d=1200594610

    I ran PasswordExtractor2000and97 on some of the MDBs and they all say:
    User: 'JH', PID: 'SUS002'

    But how do I add that user to Access2007, so I don't need to convert every database manually?
    Or is there some way I can convert them all automatically?

    Switching from Office97 Pro SR2 to Office2007 ProPlus SP1.

    Hope you have an idea, cause I'm really lost.

    -flamber

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You can't. Access 2007 stupidly doesn't support userlevel security.

    You need to address the security issue in Access 97 and then convert it. You need to give the objects back to the "admin" user.

    If I were you I would simply not "up"grade them to 2007. Upgrade them to 2003 and then just run them in 2007. But that's another issue.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Mar 2008
    Posts
    2
    I've been searching the web for many, many hours, so sadly enough - you're right :(

    I've created a combination of a batch script and autohotkey, which trunks through the entire network and converts them all. Those with errors will be logged, so I can go through them manually.

    Damn I hate Office2007. It wasn't my decision to upgrade.

    I don't think it would make much of a difference to downgrade to 2003 format, since I had all the same issues.

    Thanks a lot for clearing it up. I wasn't sure before.

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You're not alone with not liking the Office 2007 "up"grade. Seems very much like a very large step backwards to me. I only hope the next version of Access corrects many of the weaknesses of Access 2007, but somehow I think matters will only get worse.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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