var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: runtime error 3622 / Deleting from a table with an identity column
I am trying to delete a row from a linked SQL Server table in Access 2000 which has an Identity column as its primary key. I try and execute the code:
sql = "delete from dbo_mass_status_change_history where id = " & .ItemData(intCounter)
And I get the following error:
Run-time error '3622'
You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column.