>im using ADO to connect to a database, but i wanna know if i can use
>DAO with SQL< like:
>dim variable as sring
>variable = "China"
>data1.recordsource = "Select * from Providers where products like variable "
>
>Let me know if is better to use ADO than DAO, since i am using both, but i work better with ADO< talking about SQL Stuff!
>
>GRACIAS MIS AMIGOS DEL FORO DEL HILO UNIVERSAL!
>
>SALUDOS!

ADO is the MS-recommended way to access SQL Server (and almost any kind of) data. DAO is obsolete for most intents and purposes.

Also I don't even know if MS still supports it.

Heck, even ADO is going out! ADO.Net is the next thing. But ADO should be here for some time still, until everything Windows goes to .Net.

(and even then there will probably be something else newer..)