In sql server i can explicitly insert value to a identity column of a table by using
SET IDENTITY_INSERT ON . For an Access database i am using Autonumber column datatype. For this column i am not able to insert value of my own.
This link shows how the SET IDENTITY_INSERT setting can be used to fill a gap in the identity values caused by a DELETE statement.
Now how the same can be done for Access database.If i delete a row having some autonumber,then in future i want to insert same autonumber value.But i am not able to use SET IDENTITY_INSERT for access. So how the same can be done in Access.