>I would like to creat some temporary Recordsets or Tables when
>my VB6 application is running on a Client-Server concept.
>Hopefully the temp Recordsets/Tables can reside at the client's
>PC so that it would not mix up with the live Tables in the
>Database at the Server side. Any suggestions, thanks.

You can create an in-memory recordset without having to be connected to a table.

Dim rstMemory As ADODB.Recordset
    Set rstMemory = New ADODB.Recordset
    With rstMemory
        .CursorLocation = adUseClient
        .LockType = adLockPessimistic
        .Fields.Append "Field1", adChar, 4
        .Fields.Append "Field2", adDouble
        .Open
    End With