Warning: SQL error: ....Query is too complex.

G

Gary

I get the following error when trying to run a web-driven
query....there's nothing complex about it, only that it's
about a 1000 characters long...any way to get around this?

Warning: SQL error: [Microsoft][ODBC Microsoft Access
Driver] Query is too complex.
 
G

GVaught

Well, yes. You can post the SQL statement so we can see how complex it
really is.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
SQL Query Too Complex 2
Unique values divide by zero error 1
when i run my query an error message that says "query too complex 2
Too few parameters error with a IIF statement 5
Query is too complex after install Access 2007 SP 2 !? 19
Probable Access 2007 SP2 Error: Query too Complex 0

Top