Could somebody explain to me what is this thing with ADO and DAO?
I am absolutely ignorant in this. I got as far that I know that if I checked the tickbox in the Tools/References section for DAO I can use things like this:
Dim db As DAO.Database
Dim QD As QueryDef
whereas if it is unticked it gives me an error message. I am using Access2000.
Now somebody else is also writing code into the database I am working on and some of her code is obviously using ADO.
My questions:
1. Is it ok. to use both ADO and DAO in a database?
2. Is it needed to use both? Is there a way to use QueryDef and Findfirst in ADO as well with a different syntax perhaps or is there something in ADO I could use instead of these. If there is could you let me know what is it?
3. If I need to tick DAO in the references I presume others using my database would need to do it as well, is there a way to tick it programmatically?
Please interpret my question broadly as I really don't know what I am talking about.
Thanks
SWK
I am absolutely ignorant in this. I got as far that I know that if I checked the tickbox in the Tools/References section for DAO I can use things like this:
Dim db As DAO.Database
Dim QD As QueryDef
whereas if it is unticked it gives me an error message. I am using Access2000.
Now somebody else is also writing code into the database I am working on and some of her code is obviously using ADO.
My questions:
1. Is it ok. to use both ADO and DAO in a database?
2. Is it needed to use both? Is there a way to use QueryDef and Findfirst in ADO as well with a different syntax perhaps or is there something in ADO I could use instead of these. If there is could you let me know what is it?
3. If I need to tick DAO in the references I presume others using my database would need to do it as well, is there a way to tick it programmatically?
Please interpret my question broadly as I really don't know what I am talking about.
Thanks
SWK
