By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,775 Members | 2,658 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,775 IT Pros & Developers. It's quick & easy.

Query is too complex

P: n/a

I have a make table query that inserts approx. 78 fields into a
table. The query works fine in my Access 97 container. However, when
I import the query into a XP container on a different machine and try
to run it I get 'Query is too complex'. Any ideas of what's causing
the problem in XP?
Posted via
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
I have encountered that problem in the past with no one single answer that
solved it. One solution that has worked more than once was trying to
execute the query from a SQL string in code.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.