Weird occurance

S

Sandra P

I have something very strange that occcured when I opened my database this
morning. I have a table that uses autonumber for my primary key. When I
started to add a record this morning, the autonumber was 40766757. The last
number that was used yesterday was 2102. Is there anything I could have done
to cause this to happen? Or more importantly, how do I correct it?

Thanks, Sandra
 
R

Rick Brandt

Sandra said:
I have something very strange that occcured when I opened my database
this morning. I have a table that uses autonumber for my primary
key. When I started to add a record this morning, the autonumber was
40766757. The last number that was used yesterday was 2102. Is
there anything I could have done to cause this to happen? Or more
importantly, how do I correct it?

Thanks, Sandra
Click to expand...

AutoNumber can be set to increment or random. Did your setting get changed?
Gaps in AutoNumbers are normal and expected, sometimes large ones, but a
jump like that suggests something unusual. On the other hand you should
never care what the value of an AutoNumber is. Only that it be unique. If
you require a gapless, incrementing value then AutoNumber is a bad choice
for that.
 
S

Sandra P

Rick

I checked and it is set to incremental. If I view the table from the
beginning the numbers run fairly gapless with the exception of small gaps
where records were deleted, which is fine. You say that a gap that large
suggests something unusual, which is my concern. If there is a problem with
my database I would rather figure it out sooner than later. Any suggestions?
 
Top