Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    9

    Arrow Unanswered: Autonumber question

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    Boston
    Posts
    1

    Help with atonumber

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •