I have an Access 2007 database which I retrieve data from. I have set up a data source and connect via ODBC. I connect successfully to all queries except one. When I try to connect to this specific query, I get the error: "SQL error: System resource exceeded."
The query returns only 20 rows, with around 15 fields in each row. The query has four left joins but is not complicated and doesn't include any custom functions. There are no complicated formulae and ODBC should be able to cope with it. It runs perfectly fine, and within seconds, when I run directly from Access.
I have also tried connecting via OLEDB but get the same error message.
Has anyone experienced this, or a similar problem, before?
I am using QV9, SR4.
Any help appreciated.
With thanks
James
