Append Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2 K Version

I am getting a can't add due to key violations. The only field I have that
can't have duplicates is the [Order Number] field. I have searched my table
and cant find [Order Number] = 04101874 in the table but it won't allow me to
append this record.

I have also looked at the query. Every field from the tblActiveOrders is
matched up with a field from the table I am trying to append to which is
tblOrderHistory.

I have compacted and repaired both mdb's.

Any suggestions or direction on how to solve this would be greatly
appreciated.
 
Access 2 K Version

I am getting a can't add due to key violations. The only field I have that
can't have duplicates is the [Order Number] field. I have searched my table
and cant find [Order Number] = 04101874 in the table but it won't allow me to
append this record.

I have also looked at the query. Every field from the tblActiveOrders is
matched up with a field from the table I am trying to append to which is
tblOrderHistory.

I have compacted and repaired both mdb's.

Any suggestions or direction on how to solve this would be greatly
appreciated.
Click to expand...

Please post the SQL of your append query. Is Order Number a Text or a
Numeric field? Numbers don't have leading zeros - might there be a
410184?

John W. Vinson[MVP]
 
Back
Top