In an Access 97 backend I'm converting to SQL Server 8, one of the reports I am converting has a query object as its recordsource. This query object uses Access tables from 2 different Access databases (one of which is the one I' converting).
Since we're dealing with different record sources, how do I query a SQL table and a linked Access table to produce output for one report ? Can I even use one or two query objects anymore ?
Conceptually, it seems like I need to have 2 connection objects (one for Access; the other for SQL Server) to get the data in the code behind the Report's Open event. But how do I bring these two sources of data together, especially if both queries are using the same parameter for its WHERE clause ?