Linked Tables - Does Access use ADO or DAO

[honda882000]

Hello everyone,

My questions is simple, yet I could not find the answer anywhere. Does Access use ADO or DAO when querying data from linked tables connected through ODBC?

Thank you very much in advance.

 

[marianne]

what do you mean quering data? i know ADO and DAO is a mean of accessing data sources.

 

[Banana]

Well, you can use both. But the thing is that if you reference linked tables, saved queries or local tables, it's DAO by default. The only way to get ADO recordset set to a form is via code, AFAIK.

 

[honda882000]

Thank you for the quick replies. I mean if I have a table linked through ODBC, and I create a query through design view. Am I using DAO or ADO to connect and retrieve these records?

 

[Banana]

Well, as I said earlier-

f you reference linked tables, saved queries or local tables, it's DAO

Put it other way, *all* Access objects go via DAO interface, while ADO is optional and can be only chosen by going via code.

 

[marianne]

what banana is saying is that ms access uses DAO as its default engine to connect and access data to outside database. but if you create a code which is ADO in nature, then you are connect using ADO.

 

[honda882000]

Thank you very much Banana.

 

[Banana]

You're welcome. Don't forget to thank marianne as well.

 

[honda882000]

Yes, thank you both. That must have been posted right before my thank you post.