Unable to add/modify/delete records in database via ODBC connection

[matt.rankin]

Context

I am connecting Base to an MSSQL 2008 via a user ODBC DSN. Base is able to list the views & tables successfully, but no data modifications via in-built tools or forms is possible. The tables effectively present as read-only:

Screenshot shows that the Insert Record action is disabled.

Things I’ve tried

• Verifying user permissions & sample data by running SQL directly within MSSQL. This works.
• Verifying the ODBC DSN by calling it from a test .NET program using the same input values as above. This works.
• Running insert statements in Base directly via the SQL prompt. This sort of works, the row will be inserted but the Libreoffice process usually becomes non-responsive and has to be terminated. Obviously not ideal.

[RobertG]

By default Base expects: Tables without primary key aren’t editable. Does the table contain a primary key?

You could also try to change Edit → Database → Advanced Settings → Special Settings.