More Information: SQL Server will not allow you to save records in a table without a unique index. See 'Unique Index' in 'Books Online'.
Resolution: Create a Primary Key (Unique) Index on each of Access table. You can add an autonumber field to the table as a primary key. Then highlight the field, and from the edit menu, pick Primary Key.