Hi Experts



I'm using MS Access 2007 and have an import link to a view (SQL Server 2000) using ODBC connection. The view contains records more then 100000+ and when i export to excel or text file i do receive below error message.

Error Message:

ODBC -- call failed.
[Microsoft] [ODBC SQL Server Driver] Timeout expired (#0)

I have already tried the below registry editing.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\ODBC -- \ QueryTimeout

Changed the above value to 600 (10 Mins)

The view takes 4min 15 sec at Microsoft SQL Server Management Studio so the above timeout should work.

Please advice where i am going wrong.

Kind Regards
Bhavesh