Out of control Autonumber

  • Thread starter Struggling to learn solo
  • Start date
S

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

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
 
J

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]
 
S

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?
 
J

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]
 
S

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?
 
S

Struggling to learn solo

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

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

Top