I have a SQL table with an Identity field linked into an Access database. I am trying to execute the delete SQL statement below, but I am receiving a 3622 run time error.
set dbs = currentdb
dbs.Execute "delete * from tbl10_MonthlyMDExtract"
I found a reference to the error, but I am not sure how to fix it since I am not using an OpenRecordset command.
Note If you attempt to access a SQL Server 6.0 table that includes an identity column, you can trigger an erroneous 3622 error. To prevent this problem, use the dbSeeChanges option with the Options property or OpenRecordset method.