reset autonumber startup value

[Guest]

hello
I follow the steps microsoft says about the changing the autonumber
sequence into a table. Althought the work is done and the autonumber in the
table begin from the number 1 now, the form which comes from that table (its
a subform actually) does not change, it shows the old startup number....do i
have to do anything more?
Thanks

 

[Joseph Meehan]

hello
I follow the steps microsoft says about the changing the autonumber
sequence into a table. Althought the work is done and the autonumber
in the table begin from the number 1 now, the form which comes from
that table (its a subform actually) does not change, it shows the old
startup number....do i have to do anything more?
Thanks

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.

BTW the most likely reason for what you are seeing is that you have
"deleted" records and have not compacted the database. Access like many
databases does not actually delete data when you delete it. Your deleting
only marks it for deletion and hides it from your view. If that is the case
running a compact (might as well run a repair at the same time) may restart
the numbers. Note: there are other possible problems so autonumber may
still not start where you expect.

 

[Guest]

hi Joseph

I made a new DB and moved all the ellements there making compact and repair
and still nothing ...the old numbering seems to overrride the new one im
trying to force...
any other idea ?