get "record missing" error

[JR]

I copyed a table (structure only), giving it another name then changing the
key from auto number to number.

then I built an append query -- as a test -- to append the original table to
the new, empty table.

I got:

Record is deleted. (Error 3167)
You referred to a record that you deleted or that another user in a
multiuser environment deleted. Move to another record, and then try the
operation again.

Which doesn't tell me a thing since I did not delete any records at all ...
anyone have a clue as to what is going on?

Thanks!

 

[Ron2006]

That is one of the typical errors that you can receive when one or
more of the tables (or indexes) has become corrupt.

Perform a "Compact and Repair" on the mdb file that contains your
tables. If the tables are linked then it is the linked mdb that needs
to have this done to it. If the table is "local" in the mdb that
contains the forms, etc, then that is the mdb that needs to have this
done to it.

Ron

 

[Klatuu]

It could also be that the copied table structure also copied the index, but
something went wrong. I am not sure if there is a problem with two tables
have an index with the same name.