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?