Missing Autonumber

Karin Linenberger 1 Reputation point
2021-07-07T03:33:56.753+00:00

an autonumber has disappeared from my primary table, but it shows up in a report. Why is an Autonumber missing from my primary table?

Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
1,992 questions
{count} votes

4 answers

Sort by: Most helpful
  1. Karin Linenberger 1 Reputation point
    2021-07-07T03:43:05.623+00:00

    AutoNumber field keeps my records in proper order. Upon completion of data entry, I printed a report and the first thing I check is if AutoNumber is in numeric order. All AutoNumbers are in order. I check my data entry, made a couple corrections and looked at the Primary Table, which appears as:
    9554
    9555
    9556
    9558
    Obviously, 9557 is missing. I repopulated the fields as AutoNumber 9558, but the report shows 9557 AND 9558 with the same data.

    0 comments No comments

  2. Karin Linenberger 1 Reputation point
    2021-07-07T03:44:16.947+00:00

    This issue is not resolved!!!

    0 comments No comments

  3. Karin Linenberger 1 Reputation point
    2021-07-07T03:51:05.28+00:00

    I'm going to sleep now

    0 comments No comments

  4. Viki Ji_MSFT 4,411 Reputation points
    2021-07-08T02:57:45.733+00:00

    @Karin Linenberger ,
    Welcome to Q&A forum!
    Did you delete 9557 by mistake before?
    Please try the following steps to check this issue.

    1. Backup and open your Access database, change the field from “AutoNumber” to “Number” in the broken table.
    2. Switch to View mode and add the missing record.
    3. Copy and Paste only the structure of the table, and rename it to Table_structure.
      112772-image.png
    4. Change the field of Table_structure to “AutoNumber” and save it.
    5. Select the original Table, click Create>Query Wizard>Simple Query Wizard>add all Fields to Selected Fields>click Finish.
      112773-image.png
    6. Select the new Table Query, switch to Design mode, click Append>select Table_structure>OK>click Run.
      112804-image.png
    7. Then close and open the structure table to have a check.

    Besides, here is an official article How to reset an AutoNumber field value in Access may be helpful to you, please have a check.

    Any updates, please let me know.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.