I'm using ADO to add records to a table.
The code that Im using is a simpler form as follows where rsTIT010 is an
open recordset of the table 'TIT010'

When I check the MEM Usage using task manager it increases every time it
gets to the line 'rsTIT010.AddNew' the memory increases which is concerning
me if the number of records to add increases


Set rsTIT010 = New ADODB.Recordset

rsTIT010.Open "TIT010", myConnection, adOpenKeyset, adLockOptimistic, adCmdTable


For i = 1 To 10000

rsTIT010.AddNew

rsTIT010!Source = gReturnedTIT010.Source

rsTIT010.Update

Next i