it is slow to access sql server with ms access?

Hi,

I have a Access 2003 application that include two Access files(one for frontend and one for backend).it works fine.

I just move the backend Access file to SQL Server 2005.now I use Access 2003 front end to access lined tables with DAO and the linked tables are linked to SQL Server 2005 with ODBC.but I found it is very slow to access SQL Server 2005 database with Access 2003 front end..

Please let me know how to make it a little faster to access SQL Server with Access 2003.

Thanks for help

Mark

Two place to look:

FMS Inc's excellent tips on linking to ODBC and optimizing the performance. (Props to KenHigg for that link)

My simple and unfinished guide about using ODBC sources

HTH.

I believe ADO would be more efficent then DAO.