Delete Info Macro?

  • Thread starter Thread starter scott
  • Start date Start date
S

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
 
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
 
Back
Top