How do you delete all records within a table?

S

sa

If I want to place a command button on my page view, to delete all the
records from a table, how would I do this? I want the table to remain in the
database.
 
R

Rick Brandt

sa said:
If I want to place a command button on my page view, to delete all the
records from a table, how would I do this? I want the table to remain
in the database.
Click to expand...

CurrentDB.Execute "DELETE * FROM TableName", dbFailOnError
 
Top