Hi all.

I have the following apps running on the following configuration, but have some problem especially with performance issue.

- Access 2010 with Macro & Database link to SQL Server
- SQL Server 2008 R2 Express on server

My users will use form to upload data, retrieve data into Access form with Macro.
But the problem is the connection is very slow even the server location is in the same building & network domain.
Is there any configuration that I can set so I can speed up the process? Since it's a huge different if I'm using local SQL Server.

Maybe I should use DSN, Store Proc or anything to tune up the performance?


I only can do this from application side since the server itself is off limit, I only can access or create DSN on it.

Regards, Sea