ACC: "CREATE TABLE Permission Denied" Error Message in Export to SQL (95916)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
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 <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.
| Modification Type: | Major | Last Reviewed: | 5/9/2003 |
|---|
| Keywords: | kberrmsg kbprb kbusage KB95916 |
|---|
|