There is a new article by my good friend Andy Baron about improving performance and updatability for Access apps linked to SQL Server. Lots of great information in it. Here is the summary and URL.
Summary: One way to create applications that use Microsoft Office Access for creating user interfaces and that use Microsoft SQL Server for data storage is to link Office Access tables to SQL Server tables. This is the type of application created by using the SQL Server Migration Assistant for Office Access. This white paper presents techniques for improving performance and updatability in Office Access applications that use tables linked to SQL Server. (22 printed pages)