I have created a temporary recordset as follows:

Set rsMem = New adodb.Recordset
With rsMem
.CursorLocation = adUseClient
.LockType = adLockOptimistic
.Fields.Append "Code", adChar, 10
.Fields.Append "Name", adChar, 20
End With

After having appended the temp recordset with records, and then
deleted. When the next round, if I were to Find the matching
recordset, it is able to find (even it was deleted). Any way
to permanently delete the records? (like ZAP command in VFP).