DAO or ADO

A

Armin

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

Thanks in advance,

Armin
 
A

Albert D. Kallal

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

Thanks in advance,

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top