IDENTYTY_INSERT is set to OFF. (#544) RRS feed

  • Question

  • Since office updates 12325.20288 I receive the folowing error

    IDENTYTY_INSERT is set to OFF. (#544)

    when i want to add a record.

    I downgraded back to 12228.20364 and it works fine again.

    What can I do to resolve this error.

    Afrer October's updates problem, Microsoft office seems to surprise us with every folowing update?!

    Thank you for any suggestion.

    Tuesday, January 14, 2020 9:19 AM

All replies

  • So what more exactly are you trying to do? What software are you using?

    Erland Sommarskog, SQL Server MVP,

    Tuesday, January 14, 2020 10:09 PM
  • Thank you for your answer.

    I am using Microsoft Access.

    For issuing invoices I have one form with two subforms.

    Inserting a record in one of the subforms table are causing the error.

    The same is if I want to copy record directly in the table,

    but just in the new built 12325.20288.

    Tuesday, January 14, 2020 11:12 PM
  • Hi DagF,


    Welcome to SQL Server > SQL Server Data Access Forum.


    Per your description, I think your issue might be related to Azure SQL Database.  If so, please post your issue in the corresponding forum and you will get more professional help  Microsoft Access


    By the way, if you have post your issue in the corresponding forum  ,in order to close this thread, please kindly mark helpful replies or your own reply as answers. By doing so, it will benefit all community members who are having this similar issue.  Your contribution is highly appreciated.


    Best Regards,


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Wednesday, January 15, 2020 6:37 AM