Hi

The MS White Paper Optimizing Microsoft Office Access Applications Linked to SQL Server

http://msdn.microsoft.com/en-us/library/bb188204(v=sql.90).aspx

contains a useful and fairly exhaustive discussion of the issues and the means to address them.

Cheers