• IIRC, for logs look at the  XML files in  \SSMAProjects\SqlMigrationname\report folder.

    Another issue I find is that Access allows you to use field names that are reserved words that cause issues with MS SQL Server.  If the person who created the database did not create Primary keys for all tables then I would not be surprised is they also use keywords for field names. 

    FWIW:
    I had a project like this where the Access tables were not very SQL Server "friendly".   SSMA really had a horrible time with it. I finally decided to  manually create all the table in the  SQL server properly.   I used append queries to import the data.  This way many years ago when I was first learning to use SQL Server as an Access back end. SSMA back then also was not as good as it is now.