Search code examples
sqlms-accessautonumber

Equivalent of SET IDENTITY_INSERT OFF in Access

As the title suggests, is there any way of turning off an autonumber field in Access to allow me to insert a row with an id of my choosing, such as you would do with SET IDENTITY_INSERT OFF in SQL Server?

Solution

  • You can insert an ID with SQL.

    INSERT INTO Table1 (ID) Values (-10)