ADO Vs DAO

[Raul Sousa]

I used to work with DAO now i want to start working with
ADO. I have this code: Set RS = db.OpenRecordset("Table",
dbOpenDynaset). Now with ADO I thought it would be:
RS.Open "Table", But it is not working.
Can anyone tell me why?
Can anyone tell here can I found the main differences
between ADO and DAO?

 

[Alex Dybenko]

you can find few articles here for example
http://www.microsoft.com/accessdev/a-a&sa.htm#replication

online help also contains lots of sample code