I have a performance question regarding the Jet Engine supplied with VB.
For performance reasons I would like to open a query when the program loads
that serves as a sub query for several queries that are run by the
application or users. Basically the sub query functions like a View,
bringing together relevent data for groups of users.
My question is: if a user invokes a query using the loaded query as a
sub-query, does the jet use the query recordset already loaded in memory or
does it load another recordset object?
qryView_Query recordset loaded at program start.
the app, or the user then invokes a new recordset object based on the SQL
statement: SELECT * FROM qryView_Query WHERE Emp_ID = xx;, is a new
qryView_Query recordset object loaded or is the previously loaded recordset