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 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:

    Where can I buy Weight Watchers products?

    A:

    Most national retailers and large grocery stores carry a variety of Weight Watchers products. Weight Watchers items are available at: Acme, Albertsons, Biggs, Brookshire, Farm Fresh, Festival Foods, Food Lion, Giant Eagle and Ingles. Other stores that sell Weight Watcher foods include: Kroger, Market Basket, Marsh, Meijer, Pathmark, Publix, Quality Markets, Safeway, Shop Rite, Sunset and Tom’s among many others.

    Full Answer >
    Filed Under:
  • Q:

    Can you drink diet soda while pregnant?

    A:

    It is best to drink diet soda in moderation during pregnancy or omit it altogether. WebMD states that drinking artificially sweetened carbonated and non-carbonated soft drinks potentially puts pregnant women at risk for preterm delivery.

    Full Answer >
    Filed Under:

Explore