I used the SSMA back in 2008 to convert an Access 2003 db to SQL Server, it worked quite well.

The only issues were that, typical of an Access app, many of the table & column names used reserved words like Date, Description, Function etc., as well as names with spaces, punctuation and the like. Luckily there are utilities like Find and Replace (http://www.rickworld.com/products.html) under $40 USD that can help.

Don't forget that you need to add primary keys to tables that you want to edit thru the Access UI, in addition to any tables that will participate in RI.