delete a milion of records (1 Viewer)

[sal21]

I use the tipical ado ject conn with vb6 to connect a Access databse.
Now i need to delete approx 4.500.000!!! value in 43 fields in table via vbcode.
Have a fast way to make tath.?
Tks.

 

[highandwild]

Do you want to delete 4.500.000 records?

Is the 43 fields all there is in the table?

 

[sal21]

Do you want to delete 4.500.000 records?

Is the 43 fields all there is in the table?

yes! perfect

 

[highandwild]

Just run a delete query with no criteria then.