An autonumber field starting at 2 ?

[Alp Bekisoglu]

Hi there,

One question, has anyone come across such a case where the autonumber field
starts by issuing 2 as the initial number? This has been going on for quite
a while. I know that once you delete all (or even one) records from a table
with an autonumber primary index and do a "compact & repair" on the DB,
numbering should resume from 1 with the first entry from there on.

Did I get wrong information or is there something else that I'm missing?

Any help is much appreciated.

Alp

 

[Tim Ferguson]

One question, has anyone come across such a case where the autonumber
field starts by issuing 2 as the initial number? This has been going
on for quite a while.

1) Quite right: it should, and normally does, start from One. I wonder if
there is something in your setup that is starting a record and then
abandoning it. Check Startup Options for the default form.

2) "If you care what value an Autonumber has, then you probably should not
be using an Autonumber"


Hope that helps

Tim F

 

[Alp Bekisoglu]

Thanks Tim, I'll check the code. Actually I just wanted to "see" a 1 when
the user starts entering data, that's all. As long as the application is
working, it really is no problem. I just got stuck on it.

Alp

 

[Alp Bekisoglu]

Tim you were very correct! Checking the code I did find a "rst.AddNew" and
removed it. Now it works fine.
Thanks again for the advice.

Alp

 

[Tim Ferguson]

Now it works fine.

Tim F