AutoNumber in new table starts at 22

[Guest]

I designed a brand new table in Access 2003 with an AutoNumber field as the
Primary Key. The first record number was 22. Does anybody know why?

Thanks.

 

[Guest]

Hi Kokomojo,

Have you previously added 21 records and deleted them? If so, you need to
perform a compact and repair to reset the autonumber.

Is the New Values property (lower window, when you have the autonumber field
selected in table design view) set to Increment or Random? I suppose it's
possible that 22 just happened to be the first random value.

Do you have the latest service pack (SP-8) for the JET database engine
installed? See this KB article for a guide:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528

See the section subtitled: "Verify that the latest operating system service
pack is installed".


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Oops. I quoted the wrong subtitle. That should have been:

See the section subtitled:
"Verify that the latest Microsoft Jet service pack is installed"


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html

 

[larrylinsonjr]

MDB is unreliable.

Use SQL Server.

-Larry Linson, Jr

 

[Jeff Boyce]

Do you have any references or is this merely an opinion?

By the way, your name is remarkably similar to another responder in these
groups. I don't recall ever seeing him post unsupported assertions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Joseph Meehan]

MDB is unreliable.

Use SQL Server.

-Larry Linson, Jr

Aaron, we all know it is you, why bother trying to change your name.

 

[Joseph Meehan]

I designed a brand new table in Access 2003 with an AutoNumber field
as the Primary Key. The first record number was 22. Does anybody
know why?

Thanks.

I think why has been well answered, but the real question is do you
really care? If you do care, then I suggest autonumber is not the right
tool for the job.

I suggest you may not want to use Autonumber for that use. Autonumbers
are designed to provide unique numbers. It in not designed to provide
numbers in order and for a number of reasons may not do so. As a result
using them in any application where the user sees the numbers is likely to
end up with confusion.

There are other ways of providing the numbers you want depending on the
particual application.