ADO? DAO? help with these two please

[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

 

[Dan Artuso]

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

 

[Shadow]

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

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.

 

[Van T. Dinh]

It looks to me that you are using JET. In this case, as Dan advised, stick
with DAO.

If you want to try ADO, see:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/htm
l/acchap2.asp?frame=true

If the link doesn't work, copy the whole link and past into your browser as
ONE line.