How to speed up union queries?

[nayfeh]

Hi,

I have an access application with 2 linked ODBC tables. Then I used a UNION query to combine these 2 tables into one. One of my subforms are based on this union query, however, the data being input in the main form is very, very slow for users. Is there any way to make this application run faster?

Thanks.

 

[euskadi]

Might run faster if you do a maketable query and get the data closer to the user before doing the union.