SQL Server and Access

Hot Topic

Upgrading replication environment
Web Services Task Editor: The input Web Services Description Language (WSDL) file is not valid
SSRS 2005 dataset from another assembly
Where is the Northwind SQL scripts for SQL server 2005
Case Insensitive Lookups?
Opening a PDF report without the OPEN/Save Dialog
connecting to sql server from mobile device
Views Or Snowflake Schema
triggers and record data question
Visual Basic with SQL-database connection and Windows XP

SQL Server

Complicated Query with Subs for Grand Total
Strange performance problem or bug in SQL 2005.
Merge replication and SSL
Custom connection manager development sample?
Trouble setting-up witness.
Copy member data to another member
problem regarding the size of exported report from reporting services to excel format
SQL 2000 : Triggers
Error in creating a simple asp.net app similar to sample.net (as2000 samples)
Inconsistent Errors Using Bulk Insert with a Format File

SQL Server and Access

I was looking in the MSDN forums for a site for access questions. I need to modify some sql server code to work for access. I get a "missing operator" exception when I try to execute this sql server code in my new application.

I get very confused about what in a access sql command required brackets/quotes.

Where can I go in the forums to get questions addressed regarding access

Dim UpdateCommand As String

UpdateCommand = "UPDATE " & AdditionStructure.DatabaseTable & " SET ChildIndexList = @ChildIndexList FROM " & AdditionStructure.DatabaseTable & " WHERE (ID = @ID)"

Dim MyUpdateCommand As New OleDbCommand(UpdateCommand, Con)

MyUpdateCommand.Parameters.Add("@ID", AdditionStructure.ParentId)

MyUpdateCommand.Parameters.Add("@ChildIndexList", AdditionStructure.ParentChildIndexList)

MyUpdateCommand.ExecuteNonQuery()

Answer this question

SQL Server and Access

almightylinuxgod

Hi,

I'm moving this post to .NET Framework Data Access and Storage.

Ok, you place brackets on fields that has a corresponding keyword in access or sql server. Also fields witeh spaces are required to have a bracket. Quotes are mainly required o string, datetime types...

cheers,

Paul June A. Domag
Ben Taylor

Thanks, Paul.

Here's the link to the post in the Data Access and Storage forum:

http://forums.microsoft.com/msdn/ShowPost.aspx PostID=67915

David Sceppa

ADO.NET Program Manager

Microsoft
SQL Server and Access

Answer this question