Q:

What is the difference between ADO, RDA and DAO?

A:

Quick Answer

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.

  Know More

Full Answer

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.

Learn more about Nutrition & Diets

Related Questions

  • Q:

    What is the difference between animal fat and vegetable oil?

    A:

    The difference between animal fat and vegetable oil is that vegetable oil is composed mostly of polyunsaturated fats, which are missing more than one pair of hydrogens in its structure, while animal fat is composed mostly of monounsaturated fats, which are missing only a single pair of hydrogen, and saturated fats, as claimed by Dr. Mercola. Saturated and monounsaturated fats are more easily accessible and usable by the body in comparison to polyunsaturated fats. Saturated fats have all of their hydrogen atoms in place, which causes them to form a straight chain and is the reason behind why animal fats are generally solids at room temperature; however, unsaturated fats, whether it be polyunsaturated or monounsaturated fats, have kinks and bends in their molecular structure, which is why they tend to be liquid at room temperature, like vegetable oil.

    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 some differences between Roku players?

    A:

    The main differences between Roku players include the price, the speed with which users can navigate the interface, and the presence of additional features, including USB and SD card slots. The differences also include the type of remote that works with the device and voice search capabilities.

    Full Answer >
    Filed Under:
  • Q:

    What is the purpose of system software?

    A:

    System software forms an interface between software applications, such as a word processing program or an Internet browser, and computer hardware, including peripherals such as printers.

    Full Answer >
    Filed Under:

Explore