Append Query on Autonumber Field

[Penrodcigar]

Is it possible to use an append query SQL statement with DoCMD.RunSQL when updating a table that has an Autonumber ID field? I keep getting a key violation. It's no problem without the Autonumber field.

 

[fdcusa]

AutoNumber is just that - automatically generated. Therefore, including the field name in the APPEND statement is in error.

 

[TheAceMan1]

How are ya Penrodcigar . . .

[ol][li]For an [blue]Append[/blue] query append any field(s) you like except the autonumber, access will take care of this.[/li]
[li]For an [blue]Update[/blue] query use criteria to zero in on the autonumbered record to update.[/li][/ol]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

 

[Penrodcigar]

Well, I'm not sure what was the matter, but I finally worked it out. Maybe it was the update/append dichotomy. Actually I just found a work around instead of writing a new temporary table I made a form dialogue box with its record source as the table that needed updating.

Regards,
Peter Landeck

 

[JoeAtWork]

>>>use an append query SQL statement with DoCMD.RunSQL when updating a table

Your original statement of the problem is unclear as to whether you are attempting to add or edit records.

Append = Add
Update = Edit