Deleting records

[vince]

I had part of my question answered earlier, I need to
dump all of the data in a multi table db (about 1300
records in one of 8 tables) and then reset the auto
numbers to zero. Based on the advice I got..."delete all
data on tables and then repair and compact..." while that
works, is there an easier way to delete all records then
one by one.
Thanks

 

[Vince]

Opps, "edit" "select all" "delete" easy peasy

 

[Chris]

Easier method:

Create a New Query. Add your table. Make it a delete
query. Save.

Now you can double click on the query to delete all the
records from the table.

Chris