The following resources on Microsoft's SQL Server site include FMS authored articles with great information about upsizing your Access databases to SQL Server.
Microsoft SQL Server Home Migrate to SQL Server When to Migrate to SQL Server (published by FMS) Microsoft Access or SQL Server 2005: What's Right in Your Organization? (published by FMS)