Access: Delete all the records in a Table

[gheyman]

Is there an easy way to delete all the records in a table? I don't want to delete the table, just the records.

Thanks

 

[Joe4]

Yes, run this code:

DELETE * FROM [Table_Name];

You can run this from a "RunSQL" Macro command if you like. You can also add another action in to suppress the warning message (SetWarnings).