Re: update 500000 records with adodb.recordset resize the mdb from 140M to 2G
- From: "PC" <Onzin@xxxxxxxxxx>
- Date: Mon, 2 May 2005 20:47:22 +0200
Late reply and a shot in the dark
are you using access 2000 or + and ado less than 2.5
if so there is a bug that uses an entire page (4K) for 1 single record
from ado 2.5 the bug is gone
or use good old dao
"00090" <706504N@xxxxxxxxxxxxx> wrote in message
news:Xns9640AE2F99BE0140504NA02619@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
>
.
- Prev by Date: Connection Pooling and connection issues
- Next by Date: Re: Connection Pooling and connection issues
- Previous by thread: Connection Pooling and connection issues
- Next by thread: converting Access '97 to Access '03
- Index(es):
Relevant Pages
|
