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)
db.Execute (sql)

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.

Anyone? TIA!