Append Query mutually exclusive with Autonumber Primary Keys

[kart_deBlonch]

Hi All:

To the best of my knowledge, an append query will not work when appending to a table that uses an Autonumber for a primary key. Is this always true? If not, how is it done? Actually, if there is a way to do this that involves VBA, that would be good cuz I may need to write some code to take a parameter, select one record based on the parameter and then append a copy of that record, with a new primary key to the table it is copied from. Can this be done and, if yes, could someone copy some code to me? I would appreciate it.

Thanks everyone...

 

[kart_deBlonch]

Re: Append Query mutually exclusive with Autonumber Primary

Actually, I guess the problem is not so much the datatype for the primary key as it is the fact that there is a primery key. Looks like you can't use them in the append query....