J
José António Silva
Having upgraded some of my clients to Access run-time SP2 I suddenly run into
the following problem: Error 3360 Query too complex.
The remaining clients still using SP1 are fine like they have been in the
last few years with Access 2003. The query hasn’t changed. So, this should be
an Access 2007 SP2 flaw.
I’m currently using compiled accdr files ODBC linked with SQL Server. And,
yes, my query is complex. It has a UNION ALL and many fields. But it has been
running fine till now.
So, my question is.
Could anybody tell me what kind of possible query restrictions have been set
in Access 2007 SP2?
Thanks
the following problem: Error 3360 Query too complex.
The remaining clients still using SP1 are fine like they have been in the
last few years with Access 2003. The query hasn’t changed. So, this should be
an Access 2007 SP2 flaw.
I’m currently using compiled accdr files ODBC linked with SQL Server. And,
yes, my query is complex. It has a UNION ALL and many fields. But it has been
running fine till now.
So, my question is.
Could anybody tell me what kind of possible query restrictions have been set
in Access 2007 SP2?
Thanks