AutoNumber

[Dr. Edmund M. Hayes]

I made a database and tested it a few times.
I now wnat to use it in production.
I deleted all the test data.
Is there a way to tell it to start autonumbering from 1 or am I stuck
with like 29 that was from testing the database 28 times.

Thanks in advance

[fredg]

On Fri, 29 Sep 2006 19:16:42 -0400, Dr. Edmund M. Hayes wrote:

I made a database and tested it a few times.
I now wnat to use it in production.
I deleted all the test data.
Is there a way to tell it to start autonumbering from 1 or am I stuck
with like 29 that was from testing the database 28 times.

Thanks in advance

After you delete the data in the table(s) (not the tables themselves),
compact the database.
Tools + Database Utilities + Compact and Repair

Note. While this will re-set the autonumber to 0, it really shouldn't
matter what value the number is, as long as it is unique.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

[Wayne Gillespie]

On Fri, 29 Sep 2006 19:16:42 -0400, Dr. Edmund M. Hayes <[e-mail]:

>I made a database and tested it a few times.
I now wnat to use it in production.
I deleted all the test data.
Is there a way to tell it to start autonumbering from 1 or am I stuck
with like 29 that was from testing the database 28 times.

Thanks in advance

Once you have deleted all data from the table, compact the datafile. The
Autonumber will be reset and start at 1.

However, if the number generated by the Autonumber is important and needs to be
sequential, then you should not be using an autonumber. The A/N sequence will
get gaps overtime.
Wayne Gillespie
Gosford NSW Australia

[loringdo]

Dr. Edmund M. Hayes wrote:

I made a database and tested it a few times.
I now wnat to use it in production.
I deleted all the test data.
Is there a way to tell it to start autonumbering from 1 or am I stuck
with like 29 that was from testing the database 28 times.

Thanks in advance

This may help. If you deleted the test data. Open the table in design
mode. copy the field name for Autonumber. deleted save the table.
create the same autonumber field with the name and properties. It
should begin again at "1".

Hope this helps, its simple.

loringdo

[Jamey Shuemaker]

loringdo wrote:

Dr. Edmund M. Hayes wrote:

I made a database and tested it a few times.
I now wnat to use it in production.
I deleted all the test data.
Is there a way to tell it to start autonumbering from 1 or am I stuck
with like 29 that was from testing the database 28 times.

If you need anything more robust than what can be accomplished by
compacting, check the Access Security FAQ, section 3.11. It discusses
the Modify Autonumber permission that can be set via DAO. I've never
used this, but it can be done.

[Dr. Edmund M. Hayes]

Thanks again for the help.............

Ed

On Fri, 29 Sep 2006 19:16:42 -0400, Dr. Edmund M. Hayes
<[e-mail]:

>I made a database and tested it a few times.
I now wnat to use it in production.
I deleted all the test data.
Is there a way to tell it to start autonumbering from 1 or am I stuck
with like 29 that was from testing the database 28 times.

Thanks in advance

[Larry Linson]

"Dr. Edmund M. Hayes" <[e-mail] in message
news:s5********************************@4ax.com...

>I made a database and tested it a few times.
I now wnat to use it in production.
I deleted all the test data.
Is there a way to tell it to start autonumbering from 1 or am I stuck
with like 29 that was from testing the database 28 times.

Autonumbers are only guaranteed to be "unique," not to be any particular
number, and are intended to be used only internally for identification/keys,
foreign keys, and joins, so you should not have any need to reset them
(though others have told you how). They are NOT intended for presentation /
showing to users. If you have need of a sequential,
monotonically-increasing number to present to users, you can create it one
of several ways, the DMAX domain aggregate function being a common one.

Larry Linson
Microsoft Access MVP