Member Avatar for LD Company

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?

Thanks!

  • 2 Contributors
  • 1 Reply
  • 213 Views
  • 49 Minutes Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.