A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Change the starting value of an AutoNumber field



 
 
Thread Tools Display Modes
  #1  
Old November 2nd, 2008, 03:48 PM posted to microsoft.public.access.tablesdbdesign
JB
external usenet poster
 
Posts: 103
Default 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  
Old November 2nd, 2008, 05:03 PM posted to microsoft.public.access.tablesdbdesign
tina
external usenet poster
 
Posts: 1,997
Default 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  
Old November 2nd, 2008, 05:58 PM posted to microsoft.public.access.tablesdbdesign
JB
external usenet poster
 
Posts: 103
Default 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  
Old November 2nd, 2008, 06:16 PM posted to microsoft.public.access.tablesdbdesign
tina
external usenet poster
 
Posts: 1,997
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.