I am using SQL Server 2005 and dealing with table having 2 million records every thing is working good in SQL.

I linked that table with Access97 through ODBC for report writing but it is not working saying "[Microsoft][ODBC SQL Server Driver] timeout expired [#0]"after some time (but linked table showing records when we double click in access) which means only filter queries are not working

Can you help me on this?

thanks in advance


AA