A
Andrew Proctor
Hi
I have a very straightforward purchase order report which consists of
one report that has as its datasource an ODBC linked table of purchase
orders, and a subreport which has as its datasource an ODBC linked
table of purchase order items.
When I open the main report, I get a vague "ODBC call failed" error
3146, which tells me that I may not be connected to the network, which
I am.
If I delete the subreport from the main report, I can open the main
report no problem, and if I open the subreport on its own, again it
opens no problem. I only seem to get the error when I try and combine
the 2.
If, instead of using ODBC linked tables, I copy the remote tables
locally, I can open the report with its subreport as I want to.
I am using Access 2003. Anyone seen anything like this? Googling has so
far left me empty handed..
I have a very straightforward purchase order report which consists of
one report that has as its datasource an ODBC linked table of purchase
orders, and a subreport which has as its datasource an ODBC linked
table of purchase order items.
When I open the main report, I get a vague "ODBC call failed" error
3146, which tells me that I may not be connected to the network, which
I am.
If I delete the subreport from the main report, I can open the main
report no problem, and if I open the subreport on its own, again it
opens no problem. I only seem to get the error when I try and combine
the 2.
If, instead of using ODBC linked tables, I copy the remote tables
locally, I can open the report with its subreport as I want to.
I am using Access 2003. Anyone seen anything like this? Googling has so
far left me empty handed..