If you are using SQL Server 2005 or 2008, I would recommend trying out Microsoft SQL Server Migration Assistant for Access.
Download SSMA 2005 or 2008 (for your version of SQL Server) at:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=5abe098d-c7e1-46c6-994a-09a2856eef0b
Read up on Migration for Microsoft Access at:
http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx
Review Mary Chipman's Blog Post on how to use SSMA:
http://blogs.msdn.com/b/ssma/archive/2011/01/28/access-to-sql-server-migration-how-to-use-ssma.aspx