Access to SQL DB, Data Mode 'Add' Stopped working

Question

I have an Access DB that uses linked tables to SQL via OS System DSN. It has been working very well for a couple years. Recently, following a SQL maintenance action of 'shrinkdatabase' (not sure this is the cause) The Access stopped working when opening in Data Mode Add. The forms open viewing the records and allowing to move to all records in that specific table. The Forms that use a view and sort mode (tabular data) work great.

What I have tried:

1. Used the 'Linked Table Manager' to refresh the links to the SQL DB. No success
2. Checked time synchronization with server to client. No success.
3. Change from using a macro that opens the form to VB code on click with 'Docmd.OpenFormMethod'. Form opens but same result as the Macro.
4. Double checked the form for 'Allow edits' etc.
5. Server/SQL is 2016. Clients are Windows 10 Pro. No windows updates have been installed in the last two years. This is a closed system. Windows updates are only done on an absolute 'needed' bases. There has been no need as of yet.

This issue needs to be resolved. I am hoping someone has some ideas to help me out.

Answer 1

Check if the SQL Server table has a Primary Key. Without it, adds and edits might be impossible.

Thank you. None of the tables had a PK. I added a Identity column with a seed to increment by 1. I named the column 'ID'. Now the form opens up as a new blank form but when is start adding data I see an icon warning when clicked i get the Message..

ODBC--insert on a linked table 'dbo_DE_Plant' failed

[Microsoft][SQL Server Native Client 11.0]Invalid character value for cast specification (#0)

Answer 2

Check if the SQL Server table has a Primary Key. Without it, adds and edits might be impossible.