what is the maximum amount of UNIONS you can have in a query for .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

there's a form that has 16 union statements in it. It is used to show the
user the forms they can access after logging in. I've tried to add one more
form to this query and it's not working. I'm wondering if I've hit the
limitations of the union statement
 
there's a form that has 16 union statements in it. It is used to show the
user the forms they can access after logging in. I've tried to add one more
form to this query and it's not working. I'm wondering if I've hit the
limitations of the union statement
Click to expand...

I'm perplexed. What tables are you UNIONing? What does the Union query
have to do with the list of Forms in the database?

I suspect you're hitting the Query Too Complex error. A query cannot
exceed 64KBytes (varying with Access version) of *compiled* query.
Sixteen large SELECT statements unioned could very well do this; if
the SELECT statements are very compact you should be able to get quite
a few more.

But any 16-table UNION is going to be slower than molasses, and I
would not recommend using one for this purpose! Can't you just create
a table of formnames?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top