Accidentally deleted 2 records which has the primary key as autonumber. Is there a way to enter these 2 deleted records manually by temporarily disabling the autonumber field. As the table is linked to other tables, access 2000 isn't allowing me to change the autonumber to number type, for inserting the 2 records.
If you tried to enter the record directly into the table I believe the autonumber would automatically jump to the next number. The way around this that works is to append the records to the table, and his way you can use the original idumber value.