Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003

    Unanswered: About deleted record

    I have deleted one of the record in the table of employee n that was first record now when I am going to insert anoher record the employee ID(primary key) is showing 2,instead I want it to be 1.I know its data field is autonumber thats y its showing like that but is there any solution for it so i can get autonumber 1 in the field again.

    Thanking u.

  2. #2
    Join Date
    Aug 2003
    Unfortunately there is no great way to do this, but this article should help:;en-us;812718

  3. #3
    Join Date
    Dec 2002
    Glasgow, UK
    If you claer the table of all records (if this is possible) and compact the DB it will reset the autonumber.

    You could also append all the data (except the autonumber) into an identical copy of the table
    Access XP & WinXP Pro

Posting Permissions

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