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)
  • Re: How set default value
    ... Select this check box to have the program convert null values from the database to a 0 (for numeric fields) or a blank. ... To do this you could use a function such as COALSCE in SQL Server to control what is returned from the database. ... In the Default Settings Option dialog box and under the Reporting tab, ...
    (microsoft.public.vb.crystal)
  • 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)
  • Re: SQL database for use with VB6
    ... distribution that enables VB6 to access the Microsoft Jet Database. ... reason you stated. ...
    (microsoft.public.vb.general.discussion)