Auto Number Concern

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
 
D

Douglas J. Steele

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

Auto Number Reset 8
Auto Number 3
Auto Number 1
Alphanumeric Auto Number like @### 1
linking subforms to main form 2
Duplicated autonumbers 4
Auto Number 3
Preserving record ID when converting to auto number 4

Top