I use the tipical ado ject con and vb6 code.
I have a access table with approx 4.500.000 records in 43 fields.
All field are filled with value.
I use the delete * from table ecc.... but sure the code is very very slow...
Suggestion please to make a fast way to delete.
It's very slow because you're acting upon 4.5 million records in Access.
Is this a recurring process or a one-time thing? You may get better mileage out of walking your client side recordset and writing just the records you want to a brand new Access db, then operating on the new copy and discard/archive the old.