🚀 go-pugleaf

You may try use ADO Recordset object without TCustomADODataSet wrapper. Get
it with Recordset property of TADODataSet, TADOQuery, TADOTable etc. Use
AddNew method and pass field names and values as parameters to this method,
do not call Update method. Use server-side cursor.

Note that if database initially (before inserts) has empty space (for
example, some thousand rows was deleted before) this space will not be
reused.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Mike Ruskai" <spamten.knilhtrae@begonedynnaht.net> ???????/???????? ?
???????? ?????????:
news:gunaalqrneguyvaxarg.hcd9490.pminews@207.105.83.65...
> If I insert somewhere around 100,000 records into a 100MB Access database
> with about 320,000 records, the database balloons to over 500MB.
>
> After compacting, it's back down to around 130MB.
>
> Is there anything one can do to prevent the file from growing so much?
>
>
> --
>  - Mike
>
> Remove 'spambegone.net' and reverse to send e-mail.
>
>