Delete Info Macro?

[scott]

I am trying to create a macro that will delete ALL records in a table
without actually deleting the table. I tried the delete function but it
deleted the whole table.

Is there a way to do this? I need the info deleted but I need the table
to stay.

Thanks
Scott

 

[Steve Schapel]

Scott,

Make a Delete Query to clear the data from the table, and then use the
OpenQuery action in your macro to run the Delete Query.

- Steve Schapel, Microsoft Access MVP