See SET AUTOINCERROR Command.

>In trying to move some test data from production to test I tried to use "append from production". I am using an autoincrement field for id and it doesn't like the "append from" saying it is read only.
>
>I know I can scan the table and drop the values each field or can use SQL "insert into test(field1,field2) select field1,field2 from production) " but both require a listing of fields. Since this is a table with many many fields, is there a simplier way to move the data between tables with auto increment fields.
>
>
>Thanks
>Gaylen