Upsizing To SQL Server, Part 2

If you're using the SQL Server Migration Assistant for Access (SSMA Access) to migrate your Microsoft Access database back end to SQL Server 2005 as I mentioned in my previous post, then you should read Andy Baron's white paper, "Optimizing Microsoft Office Access Applications Lnked to SQL Server." He offers excellent techniques for improving performance when using linked SQL Server tables.