Auto Number Concern

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

While looking at my tables, I noted that the AutoNumber has changed
radically. Expecting the table to continue building on the three digit
autonumber, I was surprised to see 10 digit autonumbers appearing and at
times preceded by a minus sign. What gives? I created a master with a
replica...is this the source for the change? Thanks Cheese
 
Yup: when you use Replication, the AutoNumber field is changed from
Sequential to Random. There's no way for you to change that behaviour.

Fortunately, it doesn't matter. The only intent of an AutoNumber field is to
provide a (practically guaranteed) unique value that can be used as a
primary key, and 3, 102346, -353467 serves that purpose just as well as 4,
5, 6 does.
 

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

How do I get rid of "Auto Number" in forms ? 7
Auto Number Corrupt? 2
Auto insert into lookup table 1
renew autonumber 2
Synchronization Question 3
Auto Number based on another field 1
Data Entry Form and Auto Number ID 2
Update unique number 8

Back
Top