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

ID: Q209656

The information in this article applies to:

Microsoft Access 2000

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.

REFERENCES

For 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.

Additional query words: prb

Keywords : kberrmsg kbusage kbdta OdbcOthr
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb