Microsoft KB Archive/264950

= ACC2000: Error Message: &quot;ADO error: Line 1 : Incorrect Syntax Near '\'.&quot; When You Try to Save a View =

Article ID: 264950

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q264950



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

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



SYMPTOMS
In an Access project, you create a view, but when you try to save it, you receive the following error message:

ADO error: Line 1 : Incorrect syntax near '\'.



CAUSE
Your logon is not a member of the db_owner group.



RESOLUTION
To prevent this error message and to allow you to save the view, do one of the following:
 * Add the logon to the db_owners group.
 * Change the project's Connection to a user who is already a member of the db_owners group.
 * Instead of a view, create a stored procedure that contains a select statement, and then view it in Datasheet view.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Behavior
 Create a new project to the Microsoft Data Engine (MSDE) or to the Microsoft SQL Server 7.0 sample database NorthwindCS.adp. Create a new user who is not a member of the db_owner group. To do so, follow these steps:  On the Tools menu, point to Security, and then click Database Security. The SQL Server Security dialog box appears. On the Server Logins tab, click Add. In the SQL Server Login Properties window, enter a new user name.</li> Click SQL Server authentication, leaving the password blank, and then click Northwind in the default database list.</li> Click the Database Access tab, and then click to select the Permit check box to assign permissions to Northwind. Leave the default Public role selected.</li> Click OK twice to close the SQL Server security dialog boxes.</li></ol> </li> On the File menu, click Connection.</li> Verify that Use a specific user name and password is selected, and then enter the user name that you just created. Click OK to close the dialog box. This resets the connection of the project to the new user.

NOTE: When the new user is active, the table name listing will include (dbo) after each table name.</li> Click Views, and then create a new one. Add all the fields from the Categories table.</li> Try to save the new view. Note that you receive the error mentioned in the &quot;Symptoms&quot; section of this article.</li></ol>

Additional query words: pra err msg ADO error Line 1 Incorrect syntax near \

Keywords: kbbug kberrmsg kbnofix KB264950

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.