primary key question

[dinger2121]

Hello,
is it possible to run an append query on a table that has an autonumber primary key?
I keep getting key violation errors b/c of the autonumber.

Thanks

carl
MCSD, MCTS:MOSS

 

[dinger2121]

I figured out the problem. the field is a Number as a primary key, not AutoNumber, so it will not automatically apply a number. Fortnately, it is not much data, so I may be better off manually adding it instead of trying to come up with a custom function to perform a type of autonumber.

Thanks

carl
MCSD, MCTS:MOSS