Migration to SQL Server

Here a great compilation of Access to SQL Server migration resources from Mary Chipman, Microsoft, that will help to understand - do you need to migrate, when to migrate and what one can get from migration:

TechEd Online Panel (video) -  Go to  and search for: "Are we there yet? Successfully navigating the bumpy road from Access to SQL Server"

Microsoft Access or SQL Server 2005: What's Right in Your
Organization?

Optimizing Microsoft Office Access Applications Linked to SQL Server

What are the main differences between Access and SQL Server?

"The Best of Both Worlds--Access MDBs and SQL Server"

SQL Server Migration Assistant for Access (SSMA for Access)

FMS Upsizing Center

Microsoft Access Developer's Guide to SQL Server

Migration Considerations for Access 2007