Table Append Question

[TJ]

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!

 

[Allen Browne]

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]

Allen,

Thanks for the info!

Tom

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.