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
|
|||
|
|||
Change the starting value of an AutoNumber field
Hello
when I appended some data into my main table, the autonumber jumped from around 544 to 26300. There are only 276 rows in the table. The most rows I've deleted from the table would be maybe 200, when I was designing and testing the table, certainly not 25000. All I could find in Help was "Change the starting value of an AutoNumber field". I followed the instructions but that didn't work. Any suggestions on what I can do to lower the Autonumber? The table is related to 2 other tables. Thank you Jen |
#2
|
|||
|
|||
Change the starting value of an AutoNumber field
the Autonumber should be used to provide a primary key for a table, and for
nothing else. and it should never have meaning in the "real" world, or ever be seen by the user, whether in its' own table or in any table in which it's used as a foreign key. given the above, what's the reason you're concerned about the values assigned by the Autonumber? hth "JB" somehow@somewhere wrote in message ... Hello when I appended some data into my main table, the autonumber jumped from around 544 to 26300. There are only 276 rows in the table. The most rows I've deleted from the table would be maybe 200, when I was designing and testing the table, certainly not 25000. All I could find in Help was "Change the starting value of an AutoNumber field". I followed the instructions but that didn't work. Any suggestions on what I can do to lower the Autonumber? The table is related to 2 other tables. Thank you Jen |
#3
|
|||
|
|||
Change the starting value of an AutoNumber field
I know you do have a point. It stems from my need to tidy. But I should
leave it alone. Jen "tina" wrote in message ... the Autonumber should be used to provide a primary key for a table, and for nothing else. and it should never have meaning in the "real" world, or ever be seen by the user, whether in its' own table or in any table in which it's used as a foreign key. given the above, what's the reason you're concerned about the values assigned by the Autonumber? hth "JB" somehow@somewhere wrote in message ... Hello when I appended some data into my main table, the autonumber jumped from around 544 to 26300. There are only 276 rows in the table. The most rows I've deleted from the table would be maybe 200, when I was designing and testing the table, certainly not 25000. All I could find in Help was "Change the starting value of an AutoNumber field". I followed the instructions but that didn't work. Any suggestions on what I can do to lower the Autonumber? The table is related to 2 other tables. Thank you Jen |
#4
|
|||
|
|||
Change the starting value of an AutoNumber field
well, not so much "should", hon, but...you could spend hours or days fussing
with it, if you wanted to, to fix the existing records *right now*. but it's likely to just happen again as more records are added to the table, so might as well invest your valuable time and energy in something that will actually improve your database. "JB" somehow@somewhere wrote in message ... I know you do have a point. It stems from my need to tidy. But I should leave it alone. Jen "tina" wrote in message ... the Autonumber should be used to provide a primary key for a table, and for nothing else. and it should never have meaning in the "real" world, or ever be seen by the user, whether in its' own table or in any table in which it's used as a foreign key. given the above, what's the reason you're concerned about the values assigned by the Autonumber? hth "JB" somehow@somewhere wrote in message ... Hello when I appended some data into my main table, the autonumber jumped from around 544 to 26300. There are only 276 rows in the table. The most rows I've deleted from the table would be maybe 200, when I was designing and testing the table, certainly not 25000. All I could find in Help was "Change the starting value of an AutoNumber field". I followed the instructions but that didn't work. Any suggestions on what I can do to lower the Autonumber? The table is related to 2 other tables. Thank you Jen |
Thread Tools | |
Display Modes | |
|
|