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

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 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 "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 
Issue type        : kbprb

Last Reviewed: March 19, 1999