Autonumber??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

justin - 08 Apr 2005 18:32 GMT

I've created a database to store information about various
documents coming into the office, but I don't have any
actual documents to use yet so I've just been entering
fake information into the fields to make sure the database
is doing what I want it to do.

However, after I check to see that things work, I delete
all the fake information I enter.

But, the next time I go to enter information, the
Autonumber doesn't reset back to 1, it just keeps
increasing, so I'm now at number 23 even though there are
not 22 other documents in the database.

How do I make the Autonumber field reset when information
is deleted?

Thanks in advance for the help.

-justin

Reply to this Message

Rick Brandt - 08 Apr 2005 18:50 GMT

> I've created a database to store information about various
> documents coming into the office, but I don't have any
[quoted text clipped - 16 lines]
>
> -justin

You can't. AutoNumbers are designed to be unique, not sequential without
gaps. If that is a priority then don't use an AutoNmuber.

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message

anonymous@discussions.microsoft.com - 08 Apr 2005 18:58 GMT

Ok, thanks.
It's not a priority, I was just thinking it would be nice
to have the numbers reset when users started entering real
information into the system.

>-----Original Message-----
>You can't. AutoNumbers are designed to be unique, not sequential without
>gaps. If that is a priority then don't use an AutoNmuber.

Reply to this Message

John Vinson - 08 Apr 2005 19:24 GMT

>Ok, thanks.
>It's not a priority, I was just thinking it would be nice
>to have the numbers reset when users started entering real
>information into the system.

Depending on your version of Access, try compacting the database after
you've deleted all the records in the table. This resets the
autonumber (but not in all versions).

John W. Vinson[MVP]

Reply to this Message

Steve Schapel - 08 Apr 2005 23:08 GMT

Yep, John's advice is correct, and it does apply to all versions.

Signature

Steve Schapel, Microsoft Access MVP

> Depending on your version of Access, try compacting the database after
> you've deleted all the records in the table. This resets the
> autonumber (but not in all versions).
>
> John W. Vinson[MVP]

Reply to this Message

justin - 13 Apr 2005 17:10 GMT

Perfect!
thanks for the help

-justin

>-----Original Message-----
>Yep, John's advice is correct, and it does apply to all versions.
[quoted text clipped - 5 lines]
>> John W. Vinson[MVP]
>.

Reply to this Message