ACC: "CREATE TABLE Permission Denied" Err Msg in Export to SQL

 Last reviewed: May 20, 1997
Article ID: Q95916
The information in this article applies to:
  • Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

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

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 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 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 "SQL Databases," and then "pass-through queries" or ask the Microsoft Access 97 Office Assistant.

Keywords : kberrmsg kbusage OdbcOthr
Version : 1.0 1.1 2.0 7.0 97
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 20, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.