Accidentally Ran Append Query Twice; Need to Delete

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

Guest

I accidentally ran an append query too many times and need to delete the
records that were appended; I'd even settle for deleting all the records that
were appended and starting fresh. Any quick and easy way to do this?

Thanks...
 
Perhaps, is there any way to identify which records were appended? Do they
have a specific date or time? Do they have some kind of identifier that
will tell you they were from the append query?

Perhaps if you post the SQL of the append query, someone can advise you on a
specific solution.
 
I accidentally ran an append query too many times and need to delete the
records that were appended; I'd even settle for deleting all the records that
were appended and starting fresh. Any quick and easy way to do this?

Thanks...
Click to expand...

Probably not, as stated. Access doesn't keep track of which records
were appended when.

If your Append query can be converted into a select query which
(accurately) selects the same records that were appended, you may be
able to link that query to your table by some combination of fields,
and convert it to a Delete query. Without knowing your table's
structure I can't assure that this will be feasible though.

John W. Vinson[MVP]
 
Back
Top