We recently used the "SQL Server Migration Assistant for Access" to convert a client's Access 2000 application to SQL Server Management Studio. This is a FREE tool

Here is the link: http://www.microsoft.com/downloads/d...DisplayLang=en

and you will need a FREE SSMA licence key from here:
http://www.microsoft.com/downloads/d...DisplayLang=en

Good Luck!