Clear Table Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This there a way to set up a query that will clear a table. I know I can
make a query the "makes" a table and if the table already exsist then it
deletes all the data in it. However, this also deletes the formats of the
table, such as "Index: NO, no duplicates". Is this a way to get around this?
 
It is called a DELETE query.

You should periodically compact the database following deletes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
Make-table query with around 2 ml records taking too long 0
Combine Duplicates in Query 0
Queries losing fieldnames when importing from external mdb 2
Make table query: [Enter 1] AS Test 1
Using query to make a table 3
Deleting Duplicates 1
Want to edit a table based on a query of a query of several querie 2

Back
Top