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
.Fields("NEWFIELD").Value = Right("00000000" & lngCount,
lngCount = lngCount + 1
Me.ctlProg.Value = Me.ctlProg.Value + 1