I have a sequel db of users which is periodically updated by exporting to access, making changes, then re-importing amended table.
After re-importing, the records are duplicated, and the autosequence jumps to over 10,000. I only have 682 records. (That is the highest index number used.)
Why does the auto numbering go haywire?
What is the correct way to over write the old records, with the amended ones which have the same index number, and removed records marked as deleted?
Reason for doing things this way is the db is always live, and I don't want to bar users while the changes are made.
I am not very well versed in SQL db's, so any help, or pointers where to look for the instructions will be helpfull.
August 26, 2009 2:45 PM
August 27, 2009 8:20 PM