My MS Access app links to an SQL Server 2000 db which includes a linked
server.

A pass through query like "select * from linkedtable" works fine. But
"select * from linkedtable where linkedtablekey=1" fails - ODBC timeout
error.

The same thing happens when I try the queries in Query Analyzer.

This error only occurs on the production computer - the queries work fine in
the test environment.

Thanks, in advance, for suggestions.

DT