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

    Unanswered: About deleted record

    Hi,
    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
    Posts
    9
    Unfortunately there is no great way to do this, but this article should help: http://support.microsoft.com/default...b;en-us;812718

  3. #3
    Join Date
    Dec 2002
    Location
    Glasgow, UK
    Posts
    100
    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
  •