Results 1 to 2 of 2

Thread: Autonumber

  1. #1
    Star Lounger
    Join Date
    Oct 2001
    Posts
    98
    Thanks
    0
    Thanked 0 Times in 0 Posts
    After months/years of using this database when I add a new record to a table, the autonumber field is starting with about 4450, even though the numbers continue to 10321. Usually this creates an error because it is duplicating a number from another record. I have compacted and repaired the database.

    Any ideas?

    Thanks.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    [quote name='jfrasier' post='770966' date='17-Apr-2009 12:15']After months/years of using this database when I add a new record to a table, the autonumber field is starting with about 4450, even though the numbers continue to 10321. Usually this creates an error because it is duplicating a number from another record. I have compacted and repaired the database.

    Any ideas?

    Thanks.[/quote]
    Check Mark Liquorman's web site for a solution. Sorry i don't know it offhand. Do a search on it.

    Try his website at:
    http://www.liquorman.net/liquormanutilities.html

Posting Permissions

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