converting 97 to 2000 auto number field error

G

Gail

I am trying to convert a database from 97 to 2000 and am
having trouble with an Auto Number field in one of the
tables. All of the previous records are there ending with
an auto number of 108. When I try to enter a new record,
the next number that is assigns is 1291848528 with the
second new number as 1291848529.

What is happening and how can i get this to reset back to
a smaller #.

I do still have a back up to try and convert again, but I
keep getting the same results.
 

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

Top