"Incorrect syntax in Update" Error, since upsizing for Access to SQL server.
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).