ACC2000: "CREATE TABLE Permission Denied" Error Message in Export to SQL (209656)
The information in this article applies to:
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).
SYMPTOMS
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.
CAUSE
You do not have permission to use the SQL command CREATE TABLE in the
database that you are exporting the table to.
RESOLUTION
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.
REFERENCESFor 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.
Modification Type: | Minor | Last Reviewed: | 1/26/2005 |
---|
Keywords: | kberrmsg kbprb kbusage KB209656 |
---|
|