Can you explain me what's ADO?

Hi,

I've been using VB6 with Access 97 and DAO on a Novell or Windows network.
Now I would like to know what's ADO, when to use it, the advantages and disadvantages, etc.

Note: my databases aren't too big. About 70000 records in some tables...

Anybody can give me some explanation?

Thanks a lot...

Michel Jr.

Hi Michel

ADO stand's for Activex Data Object's and is microsoft's successor to DAO. It is used in the same way as DAO to manipulate databases in project's. Where it differ's from DAO is that it is a lot quicker, more reliable and you can do more with it. a good place to start learning is

http://www.microsoft.com/data/ado/


hope this helps

Ian

a few months ago we had some discussion going on about ADO

check it out
http://209.207.250.147/showthread.php?threadid=25253