Emptying a Temp Table

[Guest]

Hi. Is this the best way to empty a temp table? The table consists of only
one field and this code works, it just seems to me that there is probably a
better way (more effecient/correct code)? Thanks!

rsTemp.MoveFirst
Do While rsTemp.EOF = False
rsTemp.Delete
rsTemp.MoveNext
If rsTemp.EOF Then
Exit Do
End If
Loop

 

[Douglas J. Steele]

CurrentDb.Execute "DELETE * FROM MyTable", dbFailOnError

 

[Guest]

Thank you!

CurrentDb.Execute "DELETE * FROM MyTable", dbFailOnError