Re: Stand Alone Recordsets

I look the clone method but it simply creates a new pointer to an opened
recordset. If I close the recordset, its clone goes out too...

Yes that is what normally happens.
But you did not look hard enough...

Note: What Bob says stands.
ADO does not have an SQL engine, so there is no way to do SQL queries on
existing recordsets.

Stephen Howe


.

Relevant Pages

  • Re: error 3251
    ... the applicant table. ... It will move the Clone recordset ... >> End Sub ...
    (microsoft.public.access.formscoding)
  • Re: Datagrid multiple row selections
    ... clone of the recordset that your grid is bound to. ... the Recordset property gives you access to the underlying recordset. ... >>> It is possible to press Ctrl and make multiple selections of separate ...
    (microsoft.public.vb.database.ado)
  • Re: error 3251
    ... You have a potential data type mismatch here. ... It will move the Clone recordset ... > Private Sub Combo16_AfterUpdate ...
    (microsoft.public.access.formscoding)
  • Re: Recordset Persistence Doesnt Preserve Carriage Returns?
    ... Recordset is simply saved to an in-memory DOM and then opened from ... Just disconnect the recordset and use the Clone method ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: how to match time ranges for multiple records in a query?
    ... > ID userID day timeStart timeEnd ... What does the returned recordset look like? ... Bob Barrows ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)