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
|
|||
|
|||
Table Append Question
In Access 2K, I have a table with some 200,000 records. The table has one
field that is used to sequence the entries named "SEQ". It is a Primary Key indexed field with No Duplicates and is a AutoNumber Data Type. How do I set up an Append Query to ALWAYS append new records starting at the highest SEQ number and go higher? The Help File says to drag the SEQ field of the table I want to append onto the Append Query Grid and Access will start at the highest number automatically. This Help Tip is not working for me. Access wanted to start appending at a lower number and I got Key Violation Errors. Any ideas here? TIA! --- TJ |
#2
|
|||
|
|||
There was a bug in JET 4 that allowed Access to reset the AutoNumber too
low. The bug was fixed a couple of service packs ago, so you need to go to http://support.microsoft.com, the Downloads section, and get JET 4 SP8. That should stop the problem recurring, but you also need to reset the AutoNumber for your existing tables. Copy the code from this article: Fixing AutoNumbers when Access assigns negatives or duplicates at: http://members.iinet.net.au/~allenbrowne/ser-40.html It loops through all your Tables and resets the Seed of the Autoincrement Column if they have the problem. -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "TJ" wrote in message ... In Access 2K, I have a table with some 200,000 records. The table has one field that is used to sequence the entries named "SEQ". It is a Primary Key indexed field with No Duplicates and is a AutoNumber Data Type. How do I set up an Append Query to ALWAYS append new records starting at the highest SEQ number and go higher? The Help File says to drag the SEQ field of the table I want to append onto the Append Query Grid and Access will start at the highest number automatically. This Help Tip is not working for me. Access wanted to start appending at a lower number and I got Key Violation Errors. Any ideas here? TIA! --- TJ |
#3
|
|||
|
|||
Allen,
Thanks for the info! Tom On Thu, 21 Oct 2004 14:21:12 +0800, "Allen Browne" wrote: There was a bug in JET 4 that allowed Access to reset the AutoNumber too low. The bug was fixed a couple of service packs ago, so you need to go to http://support.microsoft.com, the Downloads section, and get JET 4 SP8. That should stop the problem recurring, but you also need to reset the AutoNumber for your existing tables. Copy the code from this article: Fixing AutoNumbers when Access assigns negatives or duplicates at: http://members.iinet.net.au/~allenbrowne/ser-40.html It loops through all your Tables and resets the Seed of the Autoincrement Column if they have the problem. --- TJ |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Automatically Delete Duplicated Data in Table | faxylady | Running & Setting Up Queries | 3 | September 29th, 2004 06:58 PM |
Semicolon delimited text query help | Al Guerra | Running & Setting Up Queries | 3 | August 12th, 2004 11:50 AM |
Complicated Databse w/many relationships | Søren | Database Design | 7 | July 13th, 2004 05:41 AM |
Table design question - advice needed | David | Database Design | 3 | June 8th, 2004 02:21 AM |