ADO? DAO? help with these two please

  • Thread starter Thread starter Shadow
  • Start date Start date
S

Shadow

Hi all,

After several years of programming access databases, I have to admit I still don't know the differences between DAO and ADO. I've been programing Access data bases using DAO for a long time. Now that I want to move to Client/server databases I want to be sure which one I have to choose.

Any kind of explanation on the differences between DAO and ADO, no matter how short it is, would be much appreciated.
Is there anywhere in the net with some explanation on these two and the differences of them?


thanks in advance
 
Hi,
Well, they're both COM components that allow you to connect to
a database and manipulate data.
DAO is optimized for Access while ADO is more generic, which is why
it doesn't have a QueryDef object and other Access specific objects.

If I'm working with Access and Jet, I'll always use DAO. For any other
database engine I'll use ADO.

Go to microsoft.com and search on ADO, plenty of info there.
Just be aware that there is also ADO.Net which has nothing to do with ADO
and is strictly for the .NET platform.

--
HTH
Dan Artuso, Access MVP


Hi all,

After several years of programming access databases, I have to admit I still don't know the differences between DAO and ADO. I've
been programing Access data bases using DAO for a long time. Now that I want to move to Client/server databases I want to be sure
which one I have to choose.

Any kind of explanation on the differences between DAO and ADO, no matter how short it is, would be much appreciated.
Is there anywhere in the net with some explanation on these two and the differences of them?


thanks in advance
 
thanks for the informations.

Just one more question.
In DAO, to access a recordset in vba I normaly do as following:

Dim db as DataBase
Dim rs as RecordSet
Set db=Currentdb()
set rs=db.OpenRecordset("Select * From tblMaster Where [User] = '" & strUser
& "'")

In ADO I'm receiving errors with the above code. How do you access the
record set of this table with ADO?

thanks for any kind of information and help


MnInShdw


Dan Artuso said:
Hi,
Well, they're both COM components that allow you to connect to
a database and manipulate data.
DAO is optimized for Access while ADO is more generic, which is why
it doesn't have a QueryDef object and other Access specific objects.

If I'm working with Access and Jet, I'll always use DAO. For any other
database engine I'll use ADO.

Go to microsoft.com and search on ADO, plenty of info there.
Just be aware that there is also ADO.Net which has nothing to do with ADO
and is strictly for the .NET platform.

--
HTH
Dan Artuso, Access MVP


Hi all,

After several years of programming access databases, I have to admit I
Click to expand...
still don't know the differences between DAO and ADO. I've
been programing Access data bases using DAO for a long time. Now that I
Click to expand...
want to move to Client/server databases I want to be sure
which one I have to choose.

Any kind of explanation on the differences between DAO and ADO, no matter
Click to expand...
how short it is, would be much appreciated.
 
Back
Top