emptying table

[tcek]

a want to delete all data in a table without deleting the
table. is there a macro command to do such a task? i am
trying to preserve the primary key in the table. i cannot
find a way to make a table with a macro that makes a
primary key.

 

[Jim/Chris]

Create a delete query

Jim

 

[Howard Brody]

Create a DeleteQuery to delete all the records in your
table and then run the query with a macro.