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...

If the data is in the new ACE (.accdb) format yu must install the "Microsoft Office 12.0 Access Database Engine" which is a free download if Access 2007 or later...

I agree that that the selected solution seam odd.

If the database is an JET (.mdb) database then you can use the free Jet Compact tool from Microsoft.

Boyd Trimmell, Microsoft Access MVP Alumni 2010-2015

aka HiTechCoach

You will need to remove the multi value field from the query.

The Multi-value data type has many limitations..

The way I have handle this is to write VBA code...