Can I assign form's recordset to ADO's rst ?

S

S.L.

I found that if I use ADO I can not write like the following, it generates
Type Mismatch error. :

Dim rst as New ADODB.Recordset

Set rst = Form!MyForm.RecordsetClone

If I change ADODB.Recordset to DAO.Recordset, Everything is OK.

1) How to assign form's recordset to ADO's rst ?
2) Except syntax,method,property I ever used on ADO, Do I also have to
change the way I programming with form's recordset ? ex., Bookmark...

TIA
 
L

Lance

In an mdb file you need to use DAO for this. Search
google for more details.

hth,
Lance
 
V

Van T. Dinh

IIRC, the Form's Recordset in an MDB is defaulted to DAO Recordset so you
can't assign it to an ADO Recordset.

However, you can create an ADO Recordset using the same Query/Table as the
Form's RecordSource.
 
S

S.L.

Thank you for your help. It make me headache for whole day. Execuse me, May
I ask you a little bit more ? Is this information in Access help file ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top