469,898 Members | 1,832 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Autonumber Problem

We have a database which has recently started driving us nuts. It, and
some of its ancestors, have been in use for about 8 years and, until last
January, everything seemed fine. However, in the last couple of months, it
has been sending messages demanding that it be repaired and compacted
several times a week.

This has never happened before.

Recently, we have found that several tables with autonumbers are generating
duplicate values. For example, we have one table with about 20,000
records. It has an autonumber column that sometimes generates the same
number twice. For example, in a couple of instances, 329 has shown up
twice when the next autonumber should be about around 20,000.

Is this autonumber problem known? I have not been able to find references
to it. Is there a quick fix to it such as applying a service pack?

Thanks.

--PatF
Nov 12 '05 #1
1 1379

"Patrick Fleury" <pf*****@removethissbcglobal.net> wrote in message
news:Xn**********************************@128.135. 12.171...
We have a database which has recently started driving us nuts. It, and
some of its ancestors, have been in use for about 8 years and, until last
January, everything seemed fine. However, in the last couple of months, it has been sending messages demanding that it be repaired and compacted
several times a week.

This has never happened before.

Recently, we have found that several tables with autonumbers are generating duplicate values. For example, we have one table with about 20,000
records. It has an autonumber column that sometimes generates the same
number twice. For example, in a couple of instances, 329 has shown up
twice when the next autonumber should be about around 20,000.

Is this autonumber problem known? I have not been able to find references
to it. Is there a quick fix to it such as applying a service pack?

Thanks.

--PatF

The first thing you should do is backup the database or save it with a
different name.

Did you compact the database? A database should be compacted occasionally,
but AFAIK the database must be failing if it is requesting to be compacted
frequently.

Check the properties in the tables to be sure the Auto number has the proper
settings, Make sure the Index is set to Yes(No duplicates)

Charlie O'Neill

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Ralph Birden | last post: by
35 posts views Thread by Traci | last post: by
26 posts views Thread by jimfortune | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.