ADO, VB and crosstab query

Hi, well I'm using VB and Access as the db. I have made a crosstab query in Access and it's work well, but when I do the same in VB through ADO (not the control) it doesn't work.

I've just copied the SQL sentence as appear in Access to VB as something like:

dim rs as ADODB.Recordset

str_sql = "crosstab query" ' this is the SQL sentence as appear in Access

' conn is a ADODB.Connection already set
Call rs.Open(str_sql, conn, adOpenStatic, adLockOptimistic)
' I've tried with adOpenDynamic too, but I haven't gotten the correct result

When I run that, the result is not that in Access is, the result with ADO and VB give me only 3 fields -columns- (in Access are about 120 fields), I mean VB and ADO just show me the fields that in Access are labeled as "row header" (well I don't know if this label is right because I have the spanish version of Access and I don't know if this is traslated this way in the english version), and those fields that are showed by VB are completely empty.

Can not ADO handle crosstab queries or what am I doing wrong

Thanks in advanced

Answer this question

ADO, VB and crosstab query

MacMark

Is this VB6/ADO If so then questions should be posted here:

http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx dg=microsoft.public.vb.database.ado&cat=en_us_5cd05fe5-859f-481b-b554-1cc88e96f96c&lang=en&cr=us
kun123
yes it's VB6/ADO, so I have posted it the URL you said in
ADO, VB and crosstab query

Answer this question