>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).

Can you please build a small sample (adding records, deleting then finding) for us to try! You don't have ZAP or anything else to do after a Delete.