Out of control Autonumber

[Struggling to learn solo]

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.!

 

[Jeff Boyce]

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

 

[John W. Vinson]

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.!

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 to learn solo]

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?

 

[John W. Vinson]

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?

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]

 

[Struggling to learn solo]

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?

 

[Jeff Boyce]

?Years of painful experience?<g>

Jeff Boyce
Microsoft Office/Access MVP

 

[Struggling to learn solo]

Gotcha!! Can you suggest some fine reading materials with exercises to
practice?

 

[John W. Vinson]

Gotcha!! Can you suggest some fine reading materials with exercises to
practice?

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]

 

[Struggling to learn solo]

You guys are terrific! Thanks for the info!

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

John W. Vinson [MVP]