Q:

What is the difference between ADO, RDA and DAO?

A:

According to Microsoft, ADO, DAO and RDO are all data access interfaces used in Visual Basic, but they differ in how recently they have been introduced and how flexible the interface is. As of 2014, ADO is the most recent, simple to use and flexible data access interface, and Microsoft feels it should be the data access interface used for Visual Basic programming.

Microsoft states that remote data objects and data access objects are outdated methods of data access interface in Visual Basic. Both RDO and DAO are still supported in Visual Basic for backward compatibility and in support of existing projects. ActiveX data objects were specifically built to interface with and use OLE DB, Microsoft's newest and most powerful data access paradigm. Due to the complexity of OLE DB, it should not be accessed directly. ADO functions as the interface allowing full use of OLE DB. ADO uses many commands similar to RDO and DAO and the OLE automation interface to facilitate and speed up retraining by individuals accustomed to the older data access interface systems. While ADO has a relatively simplistic interface, it offers a greater and more nuanced interface with OLE DB. Microsoft strongly suggests upgrading from RDO to ADO.


Is this answer helpful?

Similar Questions

  • Q:

    What is the difference between saturated and unsaturated fats?

    A:

    Unsaturated fats liquefy at room temperature, while saturated fats remain solid. Unsaturated fats have health benefits, such as lowering LDL cholesterol and raising HDL cholesterol. Saturated fats are unhealthy because they raise LDL cholesterol, clog arteries, and increase heart attack and stroke risk.

    Full Answer >
    Filed Under:
  • Q:

    What is the difference between MS-DOS and Windows?

    A:

    While MS-DOS and Windows are both Microsoft operating systems, MS-DOS uses a command line interface, while Windows uses a graphical user interface. This basically reflects the evolution of computer interfaces from text only to the manipulation of both text and icons.

    Full Answer >
    Filed Under:
  • Q:

    What is a Dim statement in Visual Basic?

    A:

    In Visual Basic, a Dim statement is used to declare a variable for use in a program. The Dim command also allocates an appropriate amount of memory for the computer to store the value of the variable.

    Full Answer >
    Filed Under:
  • Q:

    What are the benefits of drinking noni juice?

    A:

    According to Organic Facts, the major health benefits of drinking noni juice include cancer prevention, promotion of a healthy liver, maintenance of the cardiovascular system, muscle relaxation, improvement of memory and treatment of health problems, such as diabetes and gout. Organic Facts also states that the antioxidant properties of noni juice bring about anti-inflammatory, antifungal, antibacterial and antipsychotic benefits.

    Full Answer >
    Filed Under:

Explore