Pass-Thru or Linked Oracle Table

[sxschech]

Hi,

I wrote a pass-thru query to an Oracle table. This table is replacing a local MS-Access Table. I had based numerous queries (Standard Selects, CrossTabs, Summaries) off of the table. I gave the Pass-Thru query the same same as the local table so that I wouldn't have to go in and edit the other queries. When I tried to run a report that had crosstabs, I received this error:
[tt]
You can't use a pass-through query or a non-fixed-column crosstab query as a record source for a subform or subreport.
[/tt]

I tried writing a select query off the Pass-Thru, but that didn't work either, so I removed the query and then did a linked table and everything ran fine. Will there be any performance (speed) or other issues with going via a table over pass-thru?

 

[dhookom]

A crosstab generally needs to run to determine the derived columns. You can try set the Column Headings property of the crosstab query.

Duane
Hook'D on Access
MS Access MVP