Query returns different result than VB recordset

  • Thread starter Thread starter Heather Crow
  • Start date Start date
H

Heather Crow

I have a Access 2000 database which reads data via ODBC.

I have written a query which selects certain fields from 2 of the Linked
tables (with an inner join between the 2 tables). The query returns data as
expected.

I have then written some VB code which opens a recordset based on the above
query. Every time, I get one record returned (which seems to be the first
record of the expected recordset). Why do I not get the full recordset
returned in the code?
 
Back
Top