ADO is Microsoft's premier data access technology. The ADO data access technology and its partner OLE DB comprise the recommended solution for all data access. If you are developing a new application, you should definitely use ADO.
If you're considering migration to ADO, you have to decide if characteristics and benefits of ADO are enough to justify the cost of converting existing software. Older code written in RDO and DAO will not automatically convert to ADO code. However, whatever solutions you previously developed using other data access strategies can definitely be implemented using ADO. In the long run, you should convert to ADO.