Guide to Migrating from Microsoft Access to SQL Server 2005
This white paper from Microsoft covers migrating Access databases to SQL Server 2005, and discusses the differences between the two platforms.
SQL Server Migration Assistant for Access (SSMA Access) is recommended as the best tool for this type of migration, and the paper tells you how to use it to mitigate potential problems in database conversion. For additional information, also see the white paper Microsoft Access or SQL Server 2005: What's Right in Your Organization?