AUTONUMBER

[Brian C]

I was trying to add a first record to a table called
BOOKING with the primary key defined as AUTONUMBER. I made
a mistake because I needed to put a dummy record in
another table first so no record was added. However when I
then went into the BOOKING table to add the record it was
added with the field set to 2. ACCESS must be saving this
number somewhere and not reseting it if the record is not
added.

How can I reset this value so that the record when added
is given the value 1.

Thanks in advance.

 

[RobFMS]

Reset Autonumber field in Table
http://www.mvps.org/access/general/gen0006.htm

Use Autonumbers properly
http://www.mvps.org/access/general/gen0025.htm

Have Autonumber field start from a value different from 1
http://www.mvps.org/access/tables/tbl0005.htm

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[Sally Green]

Delete the record 2 so that you have no records left in
the table. Then compact the database. To do this choose
Tools / Database Utilities / Compant and Repair. This
will reset the autonumbering and you can start again.

Regards
SJG