Microsoft KB Archive/209656

= ACC2000: "CREATE TABLE Permission Denied" Error Message in Export to SQL =

Article ID: 209656

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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, owner [#262]

where is the database that you were trying to export the table to and 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.

