Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    72

    Unanswered: delete a milion of records ado + vb6

    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.
    tks.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    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.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •