MS Access hangs when comparing 2 link tables

I have 2 link tables in a MS Access database. One of the link tables links to a table in a Sybase database and the other links to a SQL Server database.

The tables structures are same and has the same data too, barring a few rows.

I tried the 'Find unmatched rows' query wizard to compare the two tables and find the number of rows which are same (and different). But the problem is this makes the MS Access hang for huge tables (10 million+ rows).

Are there any settings that I can tweak so that Access does not hang? I am using ODBC connections to Sybase and SQL Server.

One more thing I not开发者_C百科iced is when I right click on the SQL Server link table and click on open, it shows all the rows from the table. When I do the same for the Sybase one, it hangs and I have to close Access through Task Manager.

Some details: Sybase version - 12.5.3 SQL Server version - 2008 R2 MS Access Version - 2003

On the face of it I would say the problem is that access is trying to do this query locally and is pulling most of the table down the wire. This is where you often get the myth that access does this all of the time when in fact it only does it on certain edge events. Is there anyway you could narrow down the data you are comparing? Maybe the table is a list of product sales and you could do one product line at a time or something like that?