Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 209656 - Last Review: January 26, 2005 - Revision: 2.1
ACC2000: "CREATE TABLE Permission Denied" Error Message in Export to SQL
This article was previously published under Q209656
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
When you export a table from Microsoft Access to Microsoft SQL Server, you
may receive the following error message
[Microsoft][ODBC SQL Server Driver][SQL Server] CREATE TABLE permission denied, database <database>, owner <owner> [#262]
where <database> is the database that you were trying to export the table to and <owner> is the SQL Login ID of the owner of the database.
You do not have permission to use the SQL command CREATE TABLE in the
database that you are exporting the table to.
To correct this situation, the SQL system administrator or the owner of the
database must grant you CREATE TABLE permission in the database that you want to export to.
NOTE: If at least you have rights on the SQL Server, you can try using a SQL pass-through query to administer permissions.
For more information about SQL Server, click
Microsoft Access Help on the
Help menu, type
SQL Databases in the Office Assistant or
the Answer Wizard, and then click
Search to view the topics
returned.
For more information about pass-through queries, click
Microsoft Access Help on the
Help menu, type
query, pass-through in the Office Assistant or
the Answer Wizard, and then click
Search to view the topics
returned.
APPLIES TO
- Microsoft Access 2000 Standard Edition
| kberrmsg kbprb kbusage KB209656 |
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