Autonum Problems

L

LTOSH

I am using Office 2007 but it says that my database is Access 2000 File format.

I have a field MRP# that is autonumber...been working fine till today. My
next autonum should be 1747 but it wants to put in the autonum of 197...it
won't let me do anything with it becuase it is a duplicated number.

What has happened to my auto num and how do i fix it to continue adding the
next appropriate number.
Thanks!
Leslie
 

Ask a Question

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonum fields jumping 1
Table AutoNum Nightmare on My Street 2
Auto Number in table 1
Addressing items in tables with similar functions, but dissimilar fields 3
Auto number in an existing table 4
Update unique number 8
Sequential Number that matters 2
Force Autonumber to generate 0

Top