Microsoft KB Archive/202786

= ACC2000: Can't Delete, Rename, or Edit Table in SQL 6.5 Enterprise Manager =

Article ID: 202786

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q202786



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

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
If you use Access 2000 Client-Server to create a table that violates SQL Server naming conventions, you will be unable to delete, rename or edit the table in SQL Server 6.5 Enterprise Manager. If you try to do so, you receive the following error message:

Error 21770: The name  with the name of your database,   with the current name of your table, and   with the new name to give the table:   Use MyDatabase GO  SET QUOTED_IDENTIFIER ON   EXEC sp_rename 'My Old Table Name','MyNewTableName'  On the Query menu of ISQL_w, click Execute

