Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 236888 - Last Review: January 24, 2007 - Revision: 3.2
ACC97: Need Permission to Convert Database or Import Data
This article was previously published under Q236888
Moderate: Requires basic macro, coding, and interoperability skills.
On This Page
SYMPTOMS
When you try to convert or import data from an unsecured Microsoft Access database created in an earlier version of Access into Access 97, you may receive one of the following error messages:
The current user account doesn't have permissions to convert or enable the database databasename.
-or-
You don't have permissions to import, export, or link to the table tablename.
The second error message may or may not contain instructions to log on as a user with more extensive permissions.
CAUSE
See the "Resolution" section.
RESOLUTION
These error messages have three known causes and resolutions as follows:
- You have System Objects turned on. With System Objects turned on, even the Admin user or members of the Admins group are unable to convert the file or import data because only the Jet database engine has permission to modify all system tables. To hide System Objects, open a database in Access 97 and click Options on the Tools menu. Then click the View tab and click to clear the System Objects check box.
- The owner of the database or objects in the database is "Unknown." Open the database in the earlier version of Access, and then on the Tools menu, point to Security, and click User and Group Permissions. Click the Change Owner tab.
Select each of the database objects and change the owner to Admin.
If an object's owner cannot be changed, create a new database in the earlier version of Access and import all of the objects from the existing database. The owner is set to Admin for all imported objects.
- The MSysACEs and/or MSysObjects System table has become corrupted, and still contains information for objects that no longer exist in the database. Create a new database in the earlier version of Access and import all of the objects that are listed in the existing database on the Change Owners tab in the User and Group Permissions dialog box. To open this dialog box, point to Security on the Tools menu.
MORE INFORMATION
Steps to Reproduce Behavior
- In Access 95, open the sample database Northwind.mdb.
- Add a new user to the System.mdw workgroup.
- On the Tools menu, point to Security, and then click User and Group Permissions. Click the Change Owner tab.
- Make the new user owner of all database objects.
- Delete the new user. The owner of all objects is now Unknown.
- Close Northwind.mdb and quit Access 95.
- Start Access 97 and try to convert the Northwind database. Note that you receive a permissions error.
Another Way to Reproduce Behavior
- Open Access 97.
- On the Tools menu, click Options.
- In the Options dialog box, click the View tab, and then click to select the System Objects check box.
- Close the Options dialog box.
- On the File menu, point to Import, and then click Get External Data.
- Select the Access 95 version of Northwind.mdb.
- Select all of the tables to import from Northwind, and click OK. Note that you receive a permissions error.
APPLIES TO
- Microsoft Access 97 Standard Edition
Retired KB Content DisclaimerThis article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please