Results 1 to 2 of 2
  1. #1
    asearle is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    24

    Autonumber gone crazy

    Hi everyone,

    I have a table with an autonumber primary key where I am trying to add records. Unfortunately the Autonumber seems to have "lost count" and for new records is suggesting a (random) lower number which has already been allocated.

    This is weird! What is happening here?

    Indeed, it may be because I have imported the table from another (migration table) and have written the old primary key column into the new primary key column. That seemed to work fine (and I was pleased because it will save me work) but I am worried that somehow now Autonumber is not displaying the valid next entry.

    Anyway, is there a way to reset this so that MSAccess returns to selecting the next number in the Autonumber sequence?

    Many thanks,


    Alan

  2. #2
    asearle is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    24

    Solved

    Sorry everyone,

    It was my problem: I was appending several sets of data some of which had the same key (autonumber) value. That was messing it up.

    Problem solved.

    Regards,
    Alan

Please reply to this thread with any new information or opinions.

Similar Threads

  1. duplicate autonumber
    By rayc in forum Access
    Replies: 5
    Last Post: 06-19-2013, 07:50 AM
  2. Add prefix to AutoNumber
    By sirmilt in forum Database Design
    Replies: 3
    Last Post: 07-09-2010, 01:41 PM
  3. Controlling autonumber
    By Patience in forum Access
    Replies: 3
    Last Post: 06-22-2010, 04:11 AM
  4. HELP with crazy receipt numbering
    By jlm722 in forum Forms
    Replies: 15
    Last Post: 09-23-2009, 01:49 PM
  5. AUTONUMBER
    By J A F F A in forum Database Design
    Replies: 1
    Last Post: 10-03-2007, 10:30 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums