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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

You must use the dbSeeChanges option with OpenRecordSet whenaccessing a SQL Server table that has an 1
Access 2003 and SQL Server 2005 and DAO recordset 1
NEED Quick Help 1
ODBC Update on a linked table 'table name' failed 1
Error inserting into linked table from VBA 6
Increment SQL identity From Access Front End on save of record 2
what the heck does this mean? 8
My solution to Error 3155 0

Top