Pass through queries (Access front end, SQL back end) work fine, but for faster processing I’d like to define some views in SQL, but be able to call the view with a pass through query from Access and, as part of the pass through query, define the value of a variable value contained in the SQL view.
This would mean that I could define a view in SQL that would be used for a report, but the SQL view would include variables in its where clause and I would somehow be able to pass the variable through from Access.
I don’t want to use a value in a special table because with multiuser operation, more than one user might ask for the same report at the same time.
Can this be done? If so, how?
