DAO REFERENCE

If theer was an award for asking the most questions but answering none..I
would win an award!!! What reference do I need to add in the referene
library to use DAO style method of accessing record sets. Also, I using code
from peoples help which is maybe a mixture of different types e.g. DAO ADO.
Can both styles be referenced in the same database.

Sean,

I am not 100% sure, but I had to add a reference to the 'Microsoft DAO 3.6
Object Library' to get a lot of my code to work. Maybe that's what you're
looking for.

Nick

"SEAN DI''''ANNO" wrote:

If theer was an award for asking the most questions but answering none..I
would win an award!!! What reference do I need to add in the referene
library to use DAO style method of accessing record sets. Also, I using code
from peoples help which is maybe a mixture of different types e.g. DAO ADO.
Can both styles be referenced in the same database.

Tatakau wrote:

Sean,

I am not 100% sure, but I had to add a reference to the 'Microsoft DAO 3.6
Object Library' to get a lot of my code to work. Maybe that's what you're
looking for.

Nick

I agree -- in order to keep the namespace small and manageable (so you
don't have to keep specifying which of several you're talking about),
and probably also to improve computer performance, you need to
explicitly add a reference to use DAOs.

"SEAN DI''''ANNO" wrote:


If theer was an award for asking the most questions but answering none..I
would win an award!!! What reference do I need to add in the referene
library to use DAO style method of accessing record sets. Also, I using code
from peoples help which is maybe a mixture of different types e.g. DAO ADO.
Can both styles be referenced in the same database.

Yes, but if you need to use some name that happens to appear in both,
you must specify which one you mean. So I suggest adding only the
references that you need. And if you have overlapping functions (in the
sense of "types of things you might want to do"), you might want to
consider converting some of your code, as you have time, to use only one
of the available libraries that perform that common function.

-- Vincent Johns
Please feel free to quote anything I say here.