Microsoft KB Archive/95916

= ACC: &quot;CREATE TABLE Permission Denied&quot; Error Message in Export to SQL =

Article ID: 95916

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q95916



Moderate: Requires basic macro, coding, and interoperability skills.



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 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 were trying to export the table to.

NOTE: Permissions cannot be granted through Microsoft Access versions 1.0 or 1.1. You can use a SQL pass-through query in Microsoft Access versions 2.0, 7.0 and 97 to administer permissions if you have the rights to do so on the SQL Server.

For more information about Microsoft Access and SQL Server, search the Help Index for &quot;SQL Databases,&quot; and then &quot;pass-through queries&quot; or ask the Microsoft Access 97 Office Assistant.

Keywords: kberrmsg kbprb kbusage KB95916

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.