Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2015
    Posts
    1

    Unanswered: Reset Autonumber in recordset

    How to reset autonumber recordset if recordset delete in the middle of record and then the autonumber recount number back to number sequence.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Unless you use your own mechanism of generating and maintaining the nu bering sequence you cannot. The inbuilt autonnunber datatype is there to provide a means of ensuring a unique value for use within that table, it should not have any meaning outside the system itself.

    If you need a sequential numbering system then roll your own using a function that returns such a value. Wheter you use dmax or a SQL statement is upto you. In a multi user system you may also need to use record locking
    I'd rather be riding on the Tiger 800 or the Norton

Tags for this Thread

Posting Permissions

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