Error when deleting and appending to SQL table

C

Carolyn

I am getting Runtime Error 3155

ODBC insert on linked table...failed.
....Explicit value must be specified for identity column in
table "table name" when IDENTITY INSERT is set to ON.
(#545).

Why am I getting this? This is a Access front end linking
to an SQL table. I use the identity column in other
databases without problem.

Thank you for any help you can offer!
 
Top