Reading data from queries

[Andrew Ofthesong]

Hi.. in a owc i have:

Pivot.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =
\\Server1\Data.mdb"
Pivot.CommandText="SELECT Field1, Field2 FROM Query1"

and i get no data.... I created a table with the results of that query (in
access) and modify to:

Pivot.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =
\\Server1\Data.mdb"
Pivot.CommandText="SELECT Field1, Field2 FROM DummyTable"

and now i DO get data.... mmm, stragne, so now i created a query from that
table, and changed to:

Pivot.ConnectionString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source =
\\Server1\Data.mdb"
Pivot.CommandText="SELECT Field1, Field2 FROM QueryFromDummyTable"

and i still Get data.. so why when reading from the first query i get
nothing?
Perhaps, as that query crosses multiple tables, the OWC has something like a
timeout??