Hello programmers! My Library Software with DataBase is 99% finished and I have an error. When I click Save or Delete I got error message:
Cannot insert explicit value for identity column in table 'Table1' when IDENTITY_INSERT is set to OFF.

I want to know HOW to set IDENTITY_INSERT to ON. Where is that option?


What database are you using? MS SQL, Oracle, mySQL, Access, etc?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.