<div>
Most likely answer is corruption, but there have been known issues with the AutoNumber field. Most have been corrected in the ACE upgrade (i.e. moving to the .accdb format instead of the .mdb format).<br />
<br />
First, make a backup of your database. <br />
<br />
Next, try to Compact your database. How you do this depends on the version of Access you're using. In 2010, it's on the File menu (i.e. the &quot;backstage&quot; menu). Click Compact, and hopefully all will complete. If you're using 2007, it's on the &quot;Office&quot; button - click that, then Manage, and you should see the Compact option. Earlier versions had this on the Database Tools menu option.<br />
<br />
If the Compact works, you might also consider moving everything to a new, blank database. To do that, create your new database then Import everything from the old db into the new one.
</div>


Most likely answer is corruption, but there have been known issues with the AutoNumber field. Most have been corrected in the ACE upgrade (i.e. moving to the .accdb format instead of the .mdb format).

First, make a backup of your database.

Next, try to Compact your database. How you do this depends on the version of Access you're using. In 2010, it's on the File menu (i.e. the "backstage" menu). Click Compact, and hopefully all will complete. If you're using 2007, it's on the "Office" button - click that, then Manage, and you should see the Compact option. Earlier versions had this on the Database Tools menu option.

If the Compact works, you might also consider moving everything to a new, blank database. To do that, create your new database then Import everything from the old db into the new one.

<div>
<div class="content wysiwyg-content">
I have a table I have been using for years. &nbsp;It has a field named JobID that auto numbers. &nbsp;The last time I used it it jumped form 8092 to an 8 digit number. &nbsp;I can also no longer copy or &quot;save as&quot; the table. &nbsp;I get reserved error -1524 whenever I try to do this.<br />
<br />
Can anyone explain this problem or give me a workaround?
</div>
</div>


I have a table I have been using for years.  It has a field named JobID that auto numbers.  The last time I used it it jumped form 8092 to an 8 digit number.  I can also no longer copy or "save as" the table.  I get reserved error -1524 whenever I try to do this.

Can anyone explain this problem or give me a workaround?

MSAccess auto number problem

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.