RE: what is the difference between dao,rdo and ado
DAO Data Access Objects are used to access databases like foxpro ISAM s( Indexed Sequential Access Mechanism). They are used earlier. they are used for small applications lilke stand alone.RDO Remore Data Objects are used to access remote databases like Access also. they use ODBC drivers. ADO Active Data Objects are used to access any databases they can even handle large objects. They use OLEDB driver.
RE: what is the difference between dao,rdo and ado
DAO came first and was bundled with Microsoft Access but it can be used to access other databases as well but RDO is a better set of objects for accessing other types of remote databases. Both have been superceded by ADO (or ADODB) which are thread-safe and provide more functionality than the earlier DAO and RDO including disconnected record-sets.