Well, its a similar code that I use:

Dim rs As adODB.Recordset
Dim con As adODB.Connection

Set rs = New adODB.Recordset
Set con = New adODB.Connection
con.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data source=d:\Clasificacion NA.mdb")

rs.Open "select * from universo1", con, adOpenDynamic

MSHFlexGrid3.ControlSource = rs

Well I try to show the query in the gridin a form of Access XP, but I get in the Control Source: Type mistmatch (sorry my bad english I get VS in spanish)

I check the Forum and check the component Microsoft ADO Data Control 6.0

May be it's a small error, but I'm begginer.

Access shouldnt be much different than VB, so let me try to help....

Reference to Microsoft ADO Data Control 6.0:

You dont need any since you are using ADO recordset and connection objects, so you need a reference to Microsoft ActiveX Data Objects 2.x

____________________________
If you find the answer helpful, please mark this topic as solved.

Yes Goran, in the references is this reference, the 2.5

Im sorry! isn't ADO the other reference, is Microsoft DAO 3.6 Object library.

And the problem persist... Type mistmach...

Try

Set MSHFlexGrid3.ControlSource = rs

____________________________
If you find the answer helpful, please mark this topic as solved.

No Goran. Isn't work...

Well I leave this for the moment. And I have only a cuestion, in somes sites I see that the properties of this control is different that in Acces, not remember but is something like row source.

Anyway, thanks by your help!