Autonumber doesn't start at 1

Access 2000 - I always include the autonumber ID field
when I create tables, and they always start with the
value of 22 instead of 1. This occurs in existing
databases and brand new ones. Is there an option
somewhere to set the default starting number of
autonumber fields? Thanks!

Dorci

Why? As in "why do you care what value Access uses when it creates a row
identifier?" That's what Autonumber is designed to be, a unique row
identifier.

So, why does it matter? (the business need)


--
Good luck

Jeff Boyce
Access MVP

That is really interesting, because no, there is no option
to set the default starting number for a database! It
would be really cool if you could work out how you've done
that, but I expect you will just have to try re-installing
Access/Office.

(david)


"Dorci" wrote in message
...
Access 2000 - I always include the autonumber ID field
when I create tables, and they always start with the
value of 22 instead of 1. This occurs in existing
databases and brand new ones. Is there an option
somewhere to set the default starting number of
autonumber fields? Thanks!

David

FYI -- there are ways to end up with an Autonumber of 1 without
re-installing Access.

My question relates to whether the tool (Autonumber data type) was being
used in the manner it was designed to be used.

Jeff Boyce
Access MVP

Jeff/David,
I'm not referring to any specific database use at the moment. It's just intriguing (and annoying) that autonumber starts at 22 every time. When I use the little trick of appending a starting record to the table to reset the autonumber at 1, the next record created is autonumber 23! (Is there another trick to reset autonumber to 1?) Note: This isn't urgent, just a nagging curiosity.

----- Jeff Boyce wrote: -----

Dorci

Why? As in "why do you care what value Access uses when it creates a row
identifier?" That's what Autonumber is designed to be, a unique row
identifier.

So, why does it matter? (the business need)


--
Good luck

Jeff Boyce
Access MVP

That is also an interesting and important question, and I'm
glad you were able to raise that point.

(david)

"Jeff Boyce" -DISCARD_HYPHEN_TO_END wrote in message
...
David

FYI -- there are ways to end up with an Autonumber of 1 without
re-installing Access.

My question relates to whether the tool (Autonumber data type) was being
used in the manner it was designed to be used.

Jeff Boyce
Access MVP

On the current copy of Jet, it is possible to 'set', but not 'reset' the
autonumber of a table by appending a starting number and compacting.
Unless the table is empty, when it should reset to 1. But it is possible
by using ADOX:
http://allenbrowne.com/ser-40.html
or DDL:
http://support.microsoft.com/default...b;EN-US;202117

(david)


"Dorci" wrote in message
...
Jeff/David,
I'm not referring to any specific database use at the moment. It's just
intriguing (and annoying) that autonumber starts at 22 every time. When I
use the little trick of appending a starting record to the table to reset
the autonumber at 1, the next record created is autonumber 23! (Is there
another trick to reset autonumber to 1?) Note: This isn't urgent, just a
nagging curiosity.

----- Jeff Boyce wrote: -----

Dorci

Why? As in "why do you care what value Access uses when it creates a
row
identifier?" That's what Autonumber is designed to be, a unique row
identifier.

So, why does it matter? (the business need)


--
Good luck

Jeff Boyce
Access MVP

I would like to see my tables' autonumber fields reset to 1 when I delete
all the records in them, but they still pick up at the last autonumber used.
I am running Access 2000 on a Windows 2K platform. Is there a setting I
need to change to get the autonumbers to reset?

Paul Johnson

"david epsom dot com dot au" david@epsomdotcomdotau wrote in message
...
On the current copy of Jet, it is possible to 'set', but not 'reset' the
autonumber of a table by appending a starting number and compacting.
Unless the table is empty, when it should reset to 1. But it is possible
by using ADOX:
http://allenbrowne.com/ser-40.html
or DDL:
http://support.microsoft.com/default...b;EN-US;202117

(david)


"Dorci" wrote in message
...
Jeff/David,
I'm not referring to any specific database use at the moment. It's just
intriguing (and annoying) that autonumber starts at 22 every time. When I
use the little trick of appending a starting record to the table to reset
the autonumber at 1, the next record created is autonumber 23! (Is there
another trick to reset autonumber to 1?) Note: This isn't urgent, just a
nagging curiosity.

----- Jeff Boyce wrote: -----

Dorci

Why? As in "why do you care what value Access uses when it creates
a
row
identifier?" That's what Autonumber is designed to be, a unique
row
identifier.

So, why does it matter? (the business need)


--
Good luck

Jeff Boyce
Access MVP

run a Compact/Repair on your database after deleting all the records. that
should do it.


"Paul Johnson" wrote in message
...
I would like to see my tables' autonumber fields reset to 1 when I delete
all the records in them, but they still pick up at the last autonumber
used.
I am running Access 2000 on a Windows 2K platform. Is there a setting I
need to change to get the autonumbers to reset?

Paul Johnson

"david epsom dot com dot au" david@epsomdotcomdotau wrote in message
...
On the current copy of Jet, it is possible to 'set', but not 'reset' the
autonumber of a table by appending a starting number and compacting.
Unless the table is empty, when it should reset to 1. But it is possible
by using ADOX:
http://allenbrowne.com/ser-40.html
or DDL:
http://support.microsoft.com/default...b;EN-US;202117

(david)


"Dorci" wrote in message
...
Jeff/David,
I'm not referring to any specific database use at the moment. It's
just
intriguing (and annoying) that autonumber starts at 22 every time. When
I
use the little trick of appending a starting record to the table to
reset
the autonumber at 1, the next record created is autonumber 23! (Is
there
another trick to reset autonumber to 1?) Note: This isn't urgent, just
a
nagging curiosity.

----- Jeff Boyce wrote: -----

Dorci

Why? As in "why do you care what value Access uses when it
creates
a
row
identifier?" That's what Autonumber is designed to be, a unique
row
identifier.

So, why does it matter? (the business need)


--
Good luck

Jeff Boyce
Access MVP

Yes, that does it. Thank you.

"tina" wrote in message
...
run a Compact/Repair on your database after deleting all the records. that
should do it.


"Paul Johnson" wrote in message
...
I would like to see my tables' autonumber fields reset to 1 when I
delete
all the records in them, but they still pick up at the last autonumber
used.
I am running Access 2000 on a Windows 2K platform. Is there a setting I
need to change to get the autonumbers to reset?

Paul Johnson

"david epsom dot com dot au" david@epsomdotcomdotau wrote in message
...
On the current copy of Jet, it is possible to 'set', but not 'reset'
the
autonumber of a table by appending a starting number and compacting.
Unless the table is empty, when it should reset to 1. But it is
possible
by using ADOX:
http://allenbrowne.com/ser-40.html
or DDL:
http://support.microsoft.com/default...b;EN-US;202117

(david)


"Dorci" wrote in message
...
Jeff/David,
I'm not referring to any specific database use at the moment. It's
just
intriguing (and annoying) that autonumber starts at 22 every time.
When
I
use the little trick of appending a starting record to the table to
reset
the autonumber at 1, the next record created is autonumber 23! (Is
there
another trick to reset autonumber to 1?) Note: This isn't urgent,
just
a
nagging curiosity.

----- Jeff Boyce wrote: -----

Dorci

Why? As in "why do you care what value Access uses when it
creates
a
row
identifier?" That's what Autonumber is designed to be, a
unique
row
identifier.

So, why does it matter? (the business need)


--
Good luck

Jeff Boyce
Access MVP