Delete ALL Records

CK · Nov 17, 2004

I have a temp table which I populate for the purpose of generating a report
and after which, I wish to totally empty the table. How do I do that in code?
Thanks.
ck

Allen Browne · Nov 17, 2004

dbEngine(0)(0).Execute "DELETE FROM MyTempTable;", dbFailOnError

CK · Nov 17, 2004

Thanks again, Allen.
ck

Allen Browne said:
dbEngine(0)(0).Execute "DELETE FROM MyTempTable;", dbFailOnError

Delete ALL Records

CK

Allen Browne

CK