Dim a recordset

[Raas]

In 2003 the code:

Dim rst As New adodb.Recordset

works. In 2007 I can't get the software to recognize there is a recordset
typ ADODB. Any help or suggestions? How do I use an ADODB recordset in 2007?

 

[Marshall Barton]

In 2003 the code:

Dim rst As New adodb.Recordset

works. In 2007 I can't get the software to recognize there is a recordset
typ ADODB. Any help or suggestions? How do I use an ADODB recordset in 2007?

Check your References (Tools - References menu in VBA
editor). You are probably just using the default reference
libraries that have changed over different versions of
Access. In A97 it was DAO, in A2K and AXP it was ADO, In
A2003 it was switched bach to DAO.

Carefully review each checked library in the References list
and be sure to uncheck any that you do not need.

 

[Raas]

I go into Access 2007, I bring up the form in design view. I then select
code, and in the editor I select tools, then references, and I can't see a
reference to ADO, unless I'm not totally sure what I'm looking for. ADO,
ADODB nor anything close to that is in the extensive list.

I thought I knew a little about what I was doing, but I'm now totally unsure
and lost.

 

[Douglas J. Steele]

ADO should show up as "Microsoft ActiveX Data Objects 2.x Library"

 

[Raas]

Thank you. I didn't think to put the Microsoft in front of the ADOs. Now,
there are several ActiveX Data Objects listed:

(multi-dimensional) 6.0 library
2.0
2.1
2.5
2.6
2.7
2.8
Recordset 6.0

Any thoughts as to which one, or how many to load? I'm using Office 2007
and Windows Vista Enterprise Edition (school requirement).

Thanks for your patience.

 

[Douglas J. Steele]

Unless you have a need for specific functionality that's only available in
newer versions, 2.5 is probably sufficient.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Thank you. I didn't think to put the Microsoft in front of the ADOs.
Now,
there are several ActiveX Data Objects listed:

(multi-dimensional) 6.0 library
2.0
2.1
2.5
2.6
2.7
2.8
Recordset 6.0

Any thoughts as to which one, or how many to load? I'm using Office 2007
and Windows Vista Enterprise Edition (school requirement).

Thanks for your patience.

 

[Raas]

GREAT! That worked. Thanks to all of you who helped get me to this point.