Pass-through vs. ADODB.Recordset

[Trygve Lorentzen]

Hi,

pass-through:

- Fast
- On server
- Saves network traffic
- Read-only
- more?

ADODB.Recordset:
- Same as pass-through, but
- Can also be dynamic and read/write

Is this correct? Btw. I use Access to connect to a MySQL db through ODBC. As
far as I understand the ODBC Direct "methodology" it is simply using
ADODB.Recordsets instead of normal Jet RecordSets.

Can I use ADODB.Recordset objects just as I'm using Jet Recordset in forms
etc. What is the best approach to do this? Design forms using Jet recordsets
and wizards, then remove its RecordSource design-time and later set its
Recordset/RecordSource run-time when the form is opened?

I really appreciate any help/tips&tricks!

Cheers,
Trygve