VB Forum / General 2 / November 2006

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