IDENTYTY_INSERT is set to OFF. (ERR #544)

Question

I have an application made in Microsoft Access and data on MS SQL Server connected with ODBC.

Since MS Office updateed on build 12325.20288 I receive error IDENTYTY_INSERT is set to OFF. (#544)

when I want to add a record in a subform of the main form.

I downgraded MS office back to build 12228.20364 and it works fine again.

What can I do to resolve this error.

Thank you for any suggestion.

Answer 1

Yes, this is another recent bug, see

https://www.devhut.net/2020/01/17/access-bug-sql-server-identity-bug-with-access/

But I believe it has now been resolved, so updating should patch the bug.

---

Daniel Pineault, 2010-2019 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net

Answer 2

Hi,

sounds like you have been bitten by the bug described in this support article.

The bug fixing build 12325.20344 has been available since yesterday:

https://docs.microsoft.com/en-us/officeupdates/monthly-channel-2020#version-1912-january-22

You should get it within the Office update cycle or actively pull it with "Update now".

Depending on your application you may have to refresh or rebuild the link to the SQL Server tables in order to have the Identity columns recognized again.

---

Karl
http://www.AccessDevCon.com the Access Developers Conference in April 2020