Error when running append query.

[TJBernard]

I have an MS Access 2003 front-end (queries, forms, reports) connected to a SQL server back-end database (SQL Server 2000).

When I try to run an append query against any of my SQL tables with a unique identifier, I get the error...

"Explicit value must be specified for Identity Column it table 'table1' when IDENTITY_INSERT is set to ON (#545)"

I am trying to create a duplicate record process for my users, by appending data using append queries to the same table. I used the MS Access built in wizard to duplicate the main record on the form, but was going to have to use append query code to duplicate the sub-form records.

Is there anyway around this error, or am I stuck as far as writing code to run this append query on the fly?

Thank you!

T.J.

 

[boblarson]

Sounds like you aren't including the primary key field when trying to do the append.