Autonumber records inserted in gaps

Discussion in 'Access Table Design' started by Peter Kinsman, Jan 25, 2013.

  1. I have a database of about 120Mb which provides data to various front end
    programs. In most tables the first field is an Autonumber primary key.
    Today one of the programs showed error 3022. When I looked at the table,
    eight records had been inserted in a gap left by deleted records and the
    record to be added had a number that alreay existed. Other tables in the
    database behavod correctly.
    Compacting the database made the problem go away, but can anyone suggets
    what caused it please?

    Many thanks

    Peter Kinsman
     
    Peter Kinsman, Jan 25, 2013
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Marco Alting

    Autonumber records with pattern

    Marco Alting, Sep 18, 2003, in forum: Access Table Design
    Replies:
    4
    Views:
    76
    Tim Ferguson
    Sep 18, 2003
  2. S.Low

    restore autonumber records

    S.Low, Nov 22, 2003, in forum: Access Table Design
    Replies:
    5
    Views:
    122
    Bill Schulz
    Nov 24, 2003
  3. Eric Caron

    Latest autonumber inserted?

    Eric Caron, Jan 7, 2004, in forum: Access Table Design
    Replies:
    2
    Views:
    91
    Eric Caron
    Jan 8, 2004
  4. Michelle

    AutoNumber - delete records

    Michelle, Feb 5, 2004, in forum: Access Table Design
    Replies:
    2
    Views:
    79
    John Vinson
    Feb 6, 2004
  5. Randy

    Input Mask to prevent Gaps?

    Randy, Oct 11, 2005, in forum: Access Table Design
    Replies:
    5
    Views:
    79
  6. dee
    Replies:
    40
    Views:
    390
    Jamie Collins
    Aug 9, 2007
  7. ellsanto

    To Autonumber or not to Autonumber...

    ellsanto, Jun 12, 2009, in forum: Access Table Design
    Replies:
    22
    Views:
    289
    Tony Toews [MVP]
    Jun 22, 2009
  8. Leo
    Replies:
    2
    Views:
    164
    SQL Superfast
    Mar 10, 2011
Loading...