microsoft access training courses - DAO vs ADO

Resolved · Low Priority · Version Standard

Fri 27 Apr 2007, 16:53 Delegate James said...

James has attended:
Access VBA course
Excel VBA Intro Intermediate course

DAO vs ADO

Is DAO connectivity still used? and when would it be advantageous to use it over an ADO connection?

Tue 15 May 2007, 10:08 Trainer Roy said...

RE: DAO vs ADO

James,
Sorry, just picked up your query...

My understanding is that ADO does everything that DAO does, but in a more generic way. I think you would come across DAO only in code that's quite a few years old. If you were doing a major rewrite or enhancement, it might be worth migrating to ADO, but if it ain't broke ...

/Roy

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

View all Access hints and tips

microsoft access training courses - DAO vs ADO

DAO vs ADO

RE: DAO vs ADO

Access articles

Access tip:

Hide Access Tables