how do I load ADO 2.5

[heitai]

I have office 2003 and am trying to write visual basic code to manipulate
Access files. The examples all start with ADODB.connection. then there is
ADODB.recordset and ADODB.field. However, when I write cnn as AD.... a window
comes up where I should find the whole ADODB and after hitting ., I would get
a list of choices which would include connection, recordset, field and a lot
of other choices.
What has become of ADODB? I have reloaded Office 2003. A number of
documentation references say ADO 2.5 comes with Office 2003. So where is it?
What do I click on to make it operable? I also have Studio.net 2003. Has this
confused Office so when I am in Access, Access can't find ADO 2.5,
specifically can't find ADODB?

 

[RuralGuy]

While viewing any code go to Tools>References
ADO 2.5 is called "Microsoft ActiveX Data Objects 2.5 Library"

I have office 2003 and am trying to write visual basic code to manipulate
Access files. The examples all start with ADODB.connection. then there is
ADODB.recordset and ADODB.field. However, when I write cnn as AD.... a window
comes up where I should find the whole ADODB and after hitting ., I would get
a list of choices which would include connection, recordset, field and a lot
of other choices.
What has become of ADODB? I have reloaded Office 2003. A number of
documentation references say ADO 2.5 comes with Office 2003. So where is it?
What do I click on to make it operable? I also have Studio.net 2003. Has this
confused Office so when I am in Access, Access can't find ADO 2.5,
specifically can't find ADODB?

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Larry Linson]

I'd suggest, if you are dealing with Jet databases, that you find examples
for DAO (Data Access Objects), because it is the native language of Jet. The
ADO support for Jet was dropped from the MDAC at the 2.6 level, but as far
as I know, was included in Office 2003. Still, I can't say for sure, because
I have never used ADO for working with Jet... my only experience with it was
on a client's ADP database, accessing SQL Server.

Larry Linson
Microsoft Access MVP

 

[Douglas J. Steele]

Already answered in another newsgroup where you asked the same question.
(For the benefit of others, the answer is it's not required: references live
in the database itself, so as long as Albert has added the reference when he
created the database, it'll be there for all users)