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  

AutoNumber



 
 
Thread Tools Display Modes
  #1  
Old January 28th, 2005, 12:35 AM
Cindy H
external usenet poster
 
Posts: n/a
Default AutoNumber

Hi,



I'm designing a new table to replace an existing table that is populated
with data for the current application. The old table uses an AutoNumber for
its primary key. I would like the new table to also use an AutoNumber for
this key. How can it preserve the existing data in the key field and get
the AutoNumber in the new table to continue incrementing after the last
number imported from the old table. AutoNumber does not seem to like having
any existing numbers. Is there some technique for preserving the existing
sequence of numbers and still use AutoNumber in the new table?



Thanks, Cindy H.


  #2  
Old January 28th, 2005, 02:29 AM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default

You should be able to do this by running an append query to copy the data
into that table, including the autonumber field (use the autonumber field
from the original table as the source field), and then the table's
autonumber sequence should pick up from the last number in the autonumber
field.

--

Ken Snell
MS ACCESS MVP

"Cindy H" wrote in message
...
Hi,



I'm designing a new table to replace an existing table that is populated
with data for the current application. The old table uses an AutoNumber
for its primary key. I would like the new table to also use an AutoNumber
for this key. How can it preserve the existing data in the key field and
get the AutoNumber in the new table to continue incrementing after the
last number imported from the old table. AutoNumber does not seem to like
having any existing numbers. Is there some technique for preserving the
existing sequence of numbers and still use AutoNumber in the new table?



Thanks, Cindy H.




 




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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2000, autonumber fields Zyberg74 General Discussion 3 November 17th, 2004 05:24 PM
Problem with AutoNumber accessmonk Database Design 2 September 30th, 2004 08:57 PM
keeping track of "Escaped" Autonumber records Paul James Using Forms 7 September 28th, 2004 12:06 AM
Autonumber Ally H. General Discussion 7 August 27th, 2004 04:51 PM
autonumber Deepak General Discussion 3 June 18th, 2004 09:07 PM


All times are GMT +1. The time now is 03:16 AM.


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