More database bloating!

More database bloating!

Post by Carl Howart » Sat, 09 Nov 2002 21:28:47


I recently had a query whereby my access file was
bloating hugely when I added fields using ADOX, then
populated that field using an ADO recordset.  It was
suggested that I create the field with the 'ALTER TABLE'
sql statement.  This works well and aleiated some of the
issue but I find when adding the data the database still
bloats... could this be to do with the way in which I am
updating my recordset?

Any help will be gratefully received!


objRS.Open strSQL, objConn, adOpenForwardOnly,

While Not objRS.EOF
With objRS
.Fields("NEWFIELD").Value = Right("00000000" & lngCount,
End With

lngCount = lngCount + 1
Me.ctlProg.Value = Me.ctlProg.Value + 1



More database bloating!

Post by Russ Gray [M » Sun, 10 Nov 2002 06:39:25

Hi Carl

Bloating is a known Issue with Jet. I hadn't heard of Bloat with adding
fields, but certainly Jet will bloat inserting and updating records. They
don't tell us much about what goes on inside the Jet Black Box, but I
understand that this is due to the way that Jet optimizes file i/o. The
only workaround is to compact the DB occasionally.

I hope this helps,

Russ Gray
Microsoft Developer Support

This posting is provided AS IS with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit


1. Access Database Bloat

I have a co-worker who is creating a program in Access which is doing some
queries and reports.  The sample application, which came with the Access
developers pack, was ~2 megs, whereas this application was 5 megs then grew
to 11 megs in a short period of time.

This would be understandable if there was 2 to 6 times more info in the
database, but there is actually less than what was in the sample application.

What's going on?  Is this another Microsloth 'feature'?  How do you correct
this problem?

Any comments are appreciated.

|          Ian McDougall           |" Indescribable...
|==================================|    The wonderful more than you

2. Indexing on arrays

3. Database Bloat

4. another possibly original OJ joke

5. Database bloat

6. Help with trigger to log user and timestamp

7. Access97 Database Bloating

8. ASP to Stored Procedure to BCP

9. database bloat vb5 dao w/ acc97


11. Access Database Bloat with ADO/Jet 4.0

12. Database Bloat adding records to Access 2000

13. database bloat vb5 dao w/ acc97