Very Computer

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!

Carl

objRS.Open strSQL, objConn, adOpenForwardOnly,
adLockOptimistic

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

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

objrs.close

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
http://www.microsoft.com/security.