If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Autonumber
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. |
#2
|
|||
|
|||
Autonumber
"Brian C" wrote in
: How can I reset this value so that the record when added is given the value 1. You can reset an empty table by compacting and repairing the database. If there are records in it, though, then you can't (and wouldn't want to) go back over used numbers. Remember the Autonumber Commandment: "If you care what value an Autonumber has, then you probably should not be using an Autonumber" B Wishes Tim F |
Thread Tools | |
Display Modes | |
|
|