Equivalent of Truncate 1

[Dmcniell]

I need to regularly delete all rows in a temporary table and rather than use a loop to delete all records is there an Access equivalent to the SQL Server "truncate" command? I've thought about deleting the object and recreating, but I'm hoping there's a command to clear the contents of table.

Thanks in advance for sharing your expertise.

Dan

 

[dhanus]

Dear Dan

Have you tried using an SQL statement to do that ?

DELETE * from TemporaryTable

Dhanus