Accessing queries from a database 1

[DMG2000]

Hello:
Using Visual Basic 6.0, I am trying to connect to an Access database to make a form based on a query contain in the db, and am having a problem. It shows the tables contained in, but no listings for the queries. Do I have to assemble the query by hand within VB, or is it possible to connect to the query in the db?

Thanks!

 

[MichaelRed]

Shawn,

As far as I know, it is possible to run the query in MS Access, but only if you instatntiate a copy of MS Access. MS Access has been "unbundled" from the Jet dbEngine and when you address the db part, you do not "see" any of the objects except the data tables.

I often use MS Access to generate a "base" query and take the SQL it makes 'Elsewhere' (e.g. VB) to do the dynamic parts and fine tuning.

MichaelRed
There is never time to do it right but there is aqlways time to do it over

 

[DMG2000]

So your saying in order for it to work, I must have my database opened in Access in order to access the queries? Will this work under an ODBC or do I have to use and OLE DB connect?