Out of control Autonumber

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

Guest

Can someone tell me why my Autonumber which started with 5 digits all of the
sudden is going to seven digits and not in succession? It even has negative
numbers.!
 
It sounds like you expect some specific behavior from Access Autonumber.

Autonumber is primarily intended to provide a unique (if arbitrary) row
identitier. It really isn't suitable for human consumption.

Acces Autonumbers are not guaranteed to be successive. They can be
negative.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Can someone tell me why my Autonumber which started with 5 digits all of the
sudden is going to seven digits and not in succession? It even has negative
numbers.!
Click to expand...

Did you Replicate your database? or did you (perhaps unintentionally) change
the Increment property of the autonumber to Random (replicating will do this
to you)?

John W. Vinson [MVP]
 
Struggling said:
Can someone tell me why my Autonumber which started with 5 digits all
of the sudden is going to seven digits and not in succession? It even
has negative numbers.!
Click to expand...

I suggest you may not want to use Autonumber for that use. Autonumbers are
designed to provide unique numbers. It in not designed to provide numbers
in order and for a number of reasons may not do so. As a result using them
in any application where the user sees the numbers is likely to end up with
confusion.

There are other ways of providing the numbers you want depending on the
particual application.
 
Come to think of it, I did replicate it. The only thing is the database name
doesn't show it as a replica or master but it does have extra fields in it
that the help says are fields from replication. And I noticed I cannot add
fields to tables created prior to doing this. I can add new tables and add to
those but not with prior tables.
How can I overcome this?
 
Come to think of it, I did replicate it. The only thing is the database name
doesn't show it as a replica or master but it does have extra fields in it
that the help says are fields from replication. And I noticed I cannot add
fields to tables created prior to doing this. I can add new tables and add to
those but not with prior tables.
How can I overcome this?
Click to expand...

Restore your unreplicated backup from before you replicated... or google for
"unreplicate". It can be done but it's a REAL chore.


John W. Vinson [MVP]
 
Thanks guys. I am definitely going to follow the link and work on this. By
the way, how did you get this good? The knowledge you have. Are there any
good schools or books out there?
 
?Years of painful experience?<g>

Jeff Boyce
Microsoft Office/Access MVP
 
Gotcha!! Can you suggest some fine reading materials with exercises to
practice?
 
You must log in or register to reply here.

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

Autonumbers 5
Resetting Autonumbers and creating new rows 1
Auto number - number of digits 3
Autonumber Changed to Random 4
Customising an autonumber 5
renew autonumber 2
Autonumber 2
Autonumber Macro 3

Back
Top