Help with AppendQuery

  • Thread starter Thread starter wesley.allen
  • Start date Start date
W

wesley.allen

I am having a problem with an append query, looking for a little help.

I have a table that holds names of people and some other info. Each
person has a code, which is the primary key for this table. I have a
delete query set up that will delete the information if I want to take
it out.

If I later decide that I want to add this information back in, I run
the append query and get a message:

"Micosoft Access can't append all the records in the append query" and
some details of what was not appended.

Any idea why this would happen. It does not pop up if the primary code
was never in the table, but does if it was there and was deleted.

Any help is much appreciate. Have a nice day.

Thanks.
 
It still remembers the primary key if it is an autonumber. If you Compact
and Repair you can append those records.

The best way is to use a flag field named Archive and use criteria in your
queries not not pull those flagged.
 
Open the table in design view and add a field named Archive. Make the
datatype a Yes/No. Then in your queries use criteria of 0 (zero) so as not
not pull those flagged.

To Compact and Repair you click on TOOLS - Database Utilities - Compact and
Repair Database.
 
Back
Top