Duplicate many records with auto save

[Guest]

Dear all
I have Microsoft Access application and the DataBase
(SQL) so i have function that i want to Duplicate many records through
( Append Query ) BUT i have one problem that i have Gernrated number so when
i run the Append Query i got error

 

[Brendan Reynolds]

Dear all
I have Microsoft Access application and the DataBase
(SQL) so i have function that i want to Duplicate many records through
( Append Query ) BUT i have one problem that i have Gernrated number so
when
i run the Append Query i got error

You need to specify the columns to be appended and make sure you do not
include the generated column. For example, if your existing query looks
something like this ...

INSERT INTO TargetTable
SELECT *
FROM SourceTable

.... then you need to change it to something like this ..

INSERT INTO TargetTable
(SomeColumn, SomeOtherColumn)
SELECT SomeColumn, SomeOtherColumn
FROM SourceTable