Windows XP
VB 2005 Pro
SQL Server 2005 and SQL server management studio 2005 express

I have created a series of programs using a simple Access database. these programs used OLEDB and SQL, all worked fine.

Now I am trying to re-write the programs using SQL server.
my connections string:
"Data Source=computername\SQLEXPRESS;Initial Catalog=SQLfeedback;Integrated Security=True;"
I can read all and locate records fine. However when I try to change a record I get a problem.
Trace info from debug write and output window.
SQL string:
SQL = UPDATE (feedback) SET anemail = '[email protected]' WHERE (id = 1)
Errors:
A first chance exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll Incorrect syntax near '('.

The SQL string is similar (only table and item names are different) to the OLEDB version which works.
I changed all the OLEDB class methods to SqlClient class methods also checked my connection string to a SQL server wizard version of the program that worked and updated and the string was the same.

Any ideas where to look next?

__________________
Pat

I have tried insert and delete programs and these work - so this has to be a stupid error.

The program:-

1. User types in selection criteria
2. Program locates any record or records that fit criteria these are displayed.
3. Connection closed and disposed.
4. User selectes record to be updated and suppies new values and selects update button.
5. Program user key of record to be changed and new values to create sql string.
6. Connect to database sqlsconnection open database
7. create myCommand new sqlcommand using sqlstring and sqlsconnection
8. myCommand.ExecuteNonQuery()

I think it must be the SQL string ot the connection string since the sql string looks fine that leaves the connection string but what do I need for update that is not needed for insert or delete?

__________________
Pat

I changed the SQL string to
UPDATE feedback SET anemail = '[email protected]' WHERE id = 1

seems SQL server is more fussy than OLEDB with SQL string syntax.

__________________
Pat