"Incorrect syntax in Update" Error, since upsizing for Access to SQL server.
Posted on 2006-06-21
Hello Post readers,
I have recently upsized from access to SQL server using the upsize wizard and i am now going through the code and trying to make it SQL Server friendly.
I have come accross and error that i cant figure out.
I first got an error
"You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column."
to which i used this work around (Yes i tried putting in the dbseechanges but did not work).
cmdUpdateProjects.CommandType = adCmdText
cmdUpdateProjects.CommandText = " UPDATE Projects Set Work = " & "'" & rsTasks.Fields ("sumofwork").Value & "'" & " Where ProjectId = " & "'" & rsTasks.Fields ("ProjectId").Value & "'"
cmdUpdateProjects.ActiveConnection = CurrentProject.Connection
Now i get an error saying that "inccorect syntax in UPDATE....
Could anyone please check if my syntax is correct, provide me with an alternative and generally give me a heads up when doing an Access to SQL server Upsize.
Thanks in advanced.
All responses appreciated.