Maybe I am all wet?... I THOUGHT (maybe mistakenly) that you could
execute a prewritten 'query' defined in an Access (Jet .mdb) database
by writing the 'proper' adodb code in VB6. But all I seem to come up
with is executing the 'SQL equivilent' of the predefined query in VB.
My problem seems to be how in the world would I know what the SQL should
be for a prewritten query? Is there a way to 'open' the predefined view
in adodb and determine it's underlying SQL code is... and the subsequently run that SQL, which would seem to be a 'way' to execute a predefined view.
My purpose is to execute a series of predefing queries already defined
in an .mdb database, and return recordsets for each query run.
I perhaps am suffering from the 'forest for the trees' syndrom,
but I don't seem to be comming across the DOCUMENTATION to deal with
Anyone have a 'steer' for me?