SQLServer Table Linked in MS Access Database

I have one table in SQL Server whi开发者_运维百科ch is based in London. That table is linked n MS access Database which is in Mumbai.

If i try to query the Linked Table i am getting error saying ODBC call Failed. ODBC SQL Server Time Out.

Please help. Thanks in Advance

Access tables perform very poorly on anything less than a local network or at speeds like 100 mbps on the WAN connection.

In the query design view, Right Click on the query's "Canvas" area and select Properties form the drop-down list.

Change the ODBC Time-Out value from the default 60 to 0.