Append query NOT appending

  • Thread starter Thread starter Alan B. Densky
  • Start date Start date
A

Alan B. Densky

I have an Access 2000 database. I wrote an append query to append from one
table to another. The fields are all the same. The only key on the table
that I'm trying to add data to is an AutoNumber field. I am NOT trying to
append data to this field.

The problem, the query refuses to add the record(s) PERIOD. And I cannot see
any reason for this. I've done this a thousand times.

By the way, there are no security restrictions of any kind on the table or
the query.

Any ideas?

Alan D
 
Never mind. There was some kind of corruption. I deleted the autonumber
field, saved the db, then added it back and now everything works fine.

ABD
 
Back
Top