DAO or ADO

  • Thread starter Thread starter Armin
  • Start date Start date
A

Armin

What is the best way to access
dBaseIV - DAO or ADO? Linking tables is not an option.

Thanks in advance,

Armin
 
Armin said:
What is the best way to access
dBaseIV - DAO or ADO? Linking tables is not an option.

Thanks in advance,
Click to expand...

Well, if you not using linked tables, then likely it don't matter much.

However, do you have a OLEdb "dBaseIV" provider for ADO? If you don't, then
your choice is JET direct (ODBC), or ADO->OLEdb->ODBC

There is a OLEdb provider that lets you use odbc with ado. At this point, I
would probably go with ADO since that is more common, and most examples
would be written for ADO. And, if your driver is a OLEdb provider..then you
don't need odbc, and again this favors ADO. So, if you only have a OLEdb
provider, then you have to in fact use ADO to read the files.

And, I suppose which are you more familiar with? Most people are not too
familiar with setting up DAO connection strings for JET direct and odbc.
(this actually by-passes jet when you do this).

In addition, I believe that the OLEdb providers do give you additional
options like the ability to "pack" the dbase files.
 
Back
Top