If converting tables, the ssma often fails because it does not create filtered indices for indices in access which allow null.. If not PK and SQL-Server 2008 or newer the filtered indices are really easy to create like

http://stackoverflow.com/questions/767657/how-do-i-create-a-unique-constraint-that-also-allows-nulls/767702#767702

they easily could found automatically and converted ...