Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Autonumber (2003)

    How can I reset an autonumber that is already in use? I have a table that has an autonumber field and 4 records have been deleted. The remaining record is number 2387. I know that if data is now entered, the next number will be 2392. How can I get it back to 2388?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Autonumber (2003)

    See MarkLiquorman's reply to a similar question you asked in <post:=357,047>post 357,047</post:>.

Posting Permissions

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