Help: delete a group of ado records

[jusan]

Hi, I am using VB6 and Access. I am trying to delete a whole recordset. The recorset contains around 1550 records.
How can I delete it altogether?

I was trying to delete one by one. I can delete and updatebatch up to 648 records and then it starts to give me error messages.

If someone happens to know the answer, your help is highly appreciated.

 

[TomKane]

Can you use SQL? Something like DELETE * from <recordset> WHERE <criteria>

 

[jusan]

Thank you for your suggestions. We tried it and it worked fine!!