contact id out of wack

B

betty

Help! My data base contact id's are out of order. I
have over 3000 people in my database and all of a sudden
midway the 2000's the numbers turned into 9 digit numbers
and i can't get it back to consecutive order. please
help. -betty
 
A

Arvin Meyer

If you tried to replicate your database, the autonumber would change from
sequential to random. Someone could also have been playing around with the
tables and caused this. (Can you say security?) Most of the time this
doesn't matter. Unless you have an overriding reason for having your
records in consecutive order, it won't hurt anything by being random.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 

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

Create ID with consecutive numbers by month 5
Cross-Tab CSV Records 5
Auto Number ID Field 4
Using Collect Data with Related Tables 3
My first ever Access VBA Code - How'm I doin? 9
Add a number series to existing contacts (MS 2003) 1
Increasing number in Customer ID field with existing records 4
Auto ID Number with multiple prefixes 5

Top