Data Management

Security problems can foil Access 2000 upgrades

When a TechRepublic member was having trouble converting an Access 97 database into an Access 2000 database, the Technical Q&A was able to help. The solution to this member's problem hinges on a security setting.


Recently, in TechRepublic's Technical Q&A, member Rmessier wrote asking for help upgrading a database file from Microsoft Access 97 to Access 2000. He could take the file to any computer running Access 97 and open it normally, but when he tried to open it anywhere with Access 2000, he got the message The Current User Account Doesn't Have Permission To Convert Or Enable This Database.

What was particularly galling to Rmessier was that he couldn't even get to a prompt in Access 2000 that would allow him to upgrade the database file.

Four of his TechRepublic peers came to the rescue that day, and the first answer arrived within 20 minutes of Rmessier’s original post.

Get your questions answered
Periodically, we highlight questions posted by our members in the TechRepublic Technical Q&A. If you have a question that you can't seem to find an answer to, post it in the Tech Q&A! Other TechRepublic members will try to answer your question in return for TechPoints.

From the horse's mouth
In DKlippert's quick response to Rmessier, he pointed Rmessier to an article in Microsoft's Knowledge Base (MSKB), "ACC2000: 'The Current User Account Doesn't Have Permission to Convert or Enable this Database' Error" (MSKB Q232589).

This Microsoft article states that you will get the message that Rmessier got if you try to convert a database that was secured and built in an earlier version of Access.

Typically, the problem is that when a database is created, the owner of that database is also created. To find out the owner of the database, you click on the path Tools | Security | User And Group Permissions | Change Owner. You then select Database from the Object Type list, and even though the Change Owner button will be gray, you will be able to see the owner of the database.

Microsoft states that the original owner can convert the file, but if the owner cannot be found, those with Admin rights should be able to change the permission on the system tables to include Administer and then the database can be converted.

The least desirable option, according to the Microsoft article, is to import the objects into a new database file. This removes all the existing security settings from the file. Despite the suggestion not to use this option, the Microsoft article does detail how to use this method.

Need more help?
To convert an Access 2000 database to Access 2002, check out "ACC2002: 'The Current User Account Doesn't Have Permission to Convert or Enable This Database' Error Message" (MSKB Q288960).

To convert an earlier Access database to Access 97, check out "ACC97: Need Permission to Convert Database or Import Data" (MSKB Q236888).

Want to learn more about Access?
There are an abundance of articles on TechRepublic about Microsoft Access. To find those articles, simply type Access into our Advanced Search function, click the All TechRepublic checkbox, and then the Submit Advanced Search button.

 

Editor's Picks