Write Access to ACCESS after migration to SQL

[KIOhio]

I am responsible for an ACCESS data base that has been migrated to SQL server. Two tables have been added. I cannot add data to these tables. There is no blank white row to type in, and the arrows at the bottom left are grey out. The INSERT menu is also all grey. The SQL guys say this is an ACCESS issue. I need help. How can I get write access to these tables. I am at the admin/owner level.

Thanks,

Dan

 

[SQLSister]

If you do not have a uniquely identifying field in a SQL table, then Access cannot write to it. YOu must have a primary key, an identity field, a GUID or unique constaint on the SQL table to be able to write to it.