Re: update 500000 records with adodb.recordset resize the mdb from 140M to 2G

Each UPDATE causes a delete and insert. If you update every row, you double
the size of the database (at least). The upper limit of a JET database is
2GB. It sounds like you're trying to carry a ton of coal in Tupperware.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"00090" <706504N@xxxxxxxxxxxxx> wrote in message
news:Xns963FD5BA27E230140504NA02619@xxxxxxxxxxxxxxxx
>I have an access database with one table
> After I load the table with 500000 records, I compact the database
>
> now, when I update each record the table with VB6 and adodb.recordset, at
> the end, I get an error when I execute the recordset.update around the
> record # 430000 and the mdb file is around 2G
> the error is just "invalid argument" (the status value = 16 that is the
> adrecinvalid)
>
> when I debug the recordset, I can still see the fields values
>
> the table contains text fields, numeric and date values. but mostly, only
> text and numeric fields are updated.
>
> any ideas ?
>
> many thanks
>


.

Relevant Pages

  • Re: Automated Form Validation?
    ... > before putting it into the database - even down to things like making sure ... > that numeric fields contain numeric data, ... What guarantee can you give that best practice ... then the validation rules aren't going to change. ...
    (comp.lang.php)
  • Newbie auto enter question
    ... In my database there are 3 numeric fields, A, B and C, where field C = A-B. ... Prev by Date: ...
    (comp.databases.filemaker)
  • Re: help with mySQL and ORDER BY
    ... "Jochen Daum" wrote in message ... >>numeric fields.) ... > I understand what you want, but a database doesn't suppport that. ...
    (comp.lang.php)
  • numeric fields
    ... Can anyone tell me why suddenly numeric fields in a very simple database have ... I tried every combination of decimal places, format ... and it's friving me nuts!! ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Summing multiple fields
    ... Are these numeric fields? ... Rick B ... > Hello i would like to get a sum for a few different ... > database for. ...
    (microsoft.public.access.reports)