Pass Through take long time while save in MsAccess

[manoj.mcans]

Hi,

I created two seperate pass through queries in MS Access SQL Mode its take long time to save and open the same pass through queries .
My table is on server and access on my local pc via ODBC link.

Please try to resolve this issue , when i have make any changes in pass through query , i have wait for 20-30 min in save and open operation

Thanks

 

[llkhoutx]

Post your query and identify where the tables are located, i.e. on your PC or on a sever.

Combining local Access tables and server tables in a query tables an inordinate amount of time to run because, all sever records must be brought into Access to run against the local table.

Multiple simple queries run significantly faster that one complex elegant query.

Hope that this helps.