|
| 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
November 5th, 2009, 02:19 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
Appending table autonumber problem
I am appending one table to another. The autonumber field in table1 ends at
989. When I append the second table's records, it jumps the number from 989 to 575272. Why does it do that and not just number the next appended record 990? 
|
|
#2
November 5th, 2009, 08:50 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Appending table autonumber problem
hi,
MTSmith wrote: I am appending one table to another. The autonumber field in table1 ends at 989. When I append the second table's records, it jumps the number from 989 to 575272. Why does it do that and not just number the next appended record 990? Autonumber fields are not designed to be sequences with out gaps. They only ensure that you'll get a unique number. When using a sequential autonumber, the default, then it guarantees that you'll get a strictliy increasing number (Caveat: sign flip at 2^32-1). mfG -- stefan --
|
|
#3
November 5th, 2009, 09:18 AM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Appending table autonumber problem
"MTSmith" wrote in message
... I am appending one table to another. The autonumber field in table1 ends at 989. When I append the second table's records, it jumps the number from 989 to 575272. Why does it do that and not just number the next appended record 990? AutoNaumbers are for internal indexing purposes only and it's value should be of no consequence to the user. If you want sequential numbering then you'll have to do that yourself. Keith.
|
|
#4
November 5th, 2009, 02:42 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Appending table autonumber problem
I don't know but autonumbers are guaranteed to be unique, beyond that is not
guaranteed. You cannot assume they will be sequential. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "MTSmith" wrote: I am appending one table to another. The autonumber field in table1 ends at 989. When I append the second table's records, it jumps the number from 989 to 575272. Why does it do that and not just number the next appended record 990?
|
|
#5
November 5th, 2009, 04:35 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Appending table autonumber problem
MT -
In your append query, are you including a field from the second table to go into the 'autonumber' field in table1? If so, you should not have included that field in your append query. -- Daryl S "MTSmith" wrote: I am appending one table to another. The autonumber field in table1 ends at 989. When I append the second table's records, it jumps the number from 989 to 575272. Why does it do that and not just number the next appended record 990?
|
|
#6
November 6th, 2009, 11:41 PM
posted to microsoft.public.access.tablesdbdesign
|
|||
|
|||
|
Appending table autonumber problem
I may have done that. I'll check that out. Thanks for your input!
Terry "Daryl S" wrote: MT - In your append query, are you including a field from the second table to go into the 'autonumber' field in table1? If so, you should not have included that field in your append query. -- Daryl S "MTSmith" wrote: I am appending one table to another. The autonumber field in table1 ends at 989. When I append the second table's records, it jumps the number from 989 to 575272. Why does it do that and not just number the next appended record 990?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
