insert query

  • Thread starter Thread starter doug
  • Start date Start date
D

doug

i am running an insert query to add data from a form to a
table. When i run it i get an error that
states "....didnt add 1 record to the table due to key
violations..." i do not have a key set in the datatable,
would that be my error?

any suggestions what i should do, what can be done to
remedy the problem?

thanks
 
What it means is the that record you're trying to add either is using a
value for the primary key field that already exists in the table, or the
value for the primary key field is Null. In either case, the table will not
let you add such a record to the table.
 
Back
Top