Greetings to all Experts,
I hope that one of you can help me this afternoon.
I have an Access 2003 database in which I am trying to recreate a nonworking InfoMaker report. The report references what I believe to be a view in a Sybase ARIA database.
The view seems to have a parameter '@id' and will not run without an id being provided.
I need this thing to allow me to query several hundred ids.
If I set an Access query and priivde a single id in the criteria row the view returns data.
It will not run when related to an Access table only containing the id.
It will not 'SELECT ...INTO' (create a table) even if provided with an id.
Pass-through query with ReturnsRecords property set to True did not return any records (although if 'I SELECT * FROM vv_Name WHERE id = 1234' I get records).
It will not run with a subquery feeding it the id.
I am uncertain how to procede and seek my expert's advice.
Thanks in advance for you time and trouble.