So....Forms Recordset to ADO?

  • Thread starter Thread starter Raas
  • Start date Start date
R

Raas

So...how do I initially set my form's recordset to be ADO
instead of DAO?

If the only way is through ADP then what is the difference
between ADP and MDB?

By the way, Cheryl Your link to Trigeminal was extremely
helpful to me in understanding another problem I was
having with the find method and read only forms.

Thanks
 
If you are using a standard MDB database then all your forms will have DAO
recordsets, and if you want to work with them then you should use DAO. If
you are using an Access project (ADP file) then the form recordsets will be
ADO. The difference is in the database engine used - MDB files use the Jet
database engine and ADP files use SQL server as the database (or MSDE).

To use DAO you need to add a reference to the DAO object library, and its a
good idea to "disambiguate" your code by putting DAO. in front of all your
variable declarations - eg Dim rst as DAO.Recordset - especially if you are
also using ADO.

Even though Microsoft have made ADO the default data access method, its
still DAO that is used by the Jet database, and you can't avoid using DAO if
you need to work with a forms recordset/ recordsetclone. I think many people
still use just DAO in standard mdb databases.
 
Back
Top