how to make a code that can "delete all" records in a table in MS ACCESS DATABASE 03?

[psyvanz]

any code that can delete all records in just one click

if you have a dataenvironment code it more good.. cause im working in this kind of code.

like this:

single delete code (not all in the records) dataenvironment 1.command1.dele te

thats all i can do... i want to know how to create a code that can delete all records code in just a single click... of a command button..

all answers/ replies is much appreciated..

thanks in advance and more power... and happy new year.... GOD bless...

[vb5prgrmr]

strSQL = "DELETE * FROM tablename"
Cmd.Execute strSQL

i.e. that is using ADO command object...



Good Luck