Access

[Guest]

In one of my tables I have a field that is 'AutoNumber'. I would like to
reset the number, before delivery to clients. Please tell me how to reset
this field.

 

[John W. Vinson]

In one of my tables I have a field that is 'AutoNumber'. I would like to
reset the number, before delivery to clients. Please tell me how to reset
this field.

It shouldn't matter. Autonumbers have one purpose, and one purpose only: to
provide a guaranteed unique key. They aren't suitable for human viewing, and
generally should not be exposed to user view at all. It makes no difference
whatsoever if the autonumber primary key of the first record is 1, or 3125, or
-154122591, just so long as it's unique within the table.

That said... depending on your version of Access, you may be able to delete
all records in the table and then use Tools... Database Utilities... Compact
and Repair. There are more elaborate tricks to set the starting point but
again... it shouldn't make any difference.

John W. Vinson [MVP]

 

[Guest]

Mr Vinson,

couldn't he/she just delete the data, delete the field, and then readd the
field?

may have to reestablish relations, that could be cumberson.

 

[John W. Vinson]

Mr Vinson,

couldn't he/she just delete the data, delete the field, and then readd the
field?

In some versions of Access, that may be the best way to do this.

may have to reestablish relations, that could be cumberson.

Yep.

John W. Vinson [MVP]

 

[lrnathantrc]

It is very easy guy/madam.

do the following.
1. open the table in design mode and convert the Autonumber to Number
2. save the table.
3. open the table delete all the records and save the same
close the access and come out.

then
do the following.
1. open the table in design mode and convert the Number to Autonumber
2. save the table.

then you find that the inital value is one only.

 

[Douglas J. Steele]

There's seldom a need to convert the data type. In most versions of Access,
deleting the data and compacting the database will reset the starting
number.