Hi!

I have trouble accessing data from a query. I am using VS.NET 2003 against ACcess 2000.

The acces query returns two fields and many rows. The query works fine in access. How should i set it up in vb .net to retrieve all the data from the query ? I tried using a datareader but i always get the message that 'Microsoft Jet cannot find table or query...'. ( Yes the query name is correctly spelled in the code ) ;-)

Any help would be greatly appreciated. It is the first time i use these tools togheter and am currently quite confused.

Thanks