Is it possible to execute a query that is stored in a MS Access database? Also, if that’s possible, how would one go about using parameters.
For example, let’s say I have an Access DB with a table called “quotes” an a query called “ResultsByTicker” with SQL something like:
select * from quotes where ticker = ". Ideally, the user would be prompted for the ticker symbol which would be passed to the query.