>Hello Jeffrey
>
>I have just done the following and it seems ok.
>
>1. Start off by adding normal integer field instead of an autoincrementing one.
>2. Use replace to populate the field with numbers as required. I used the record number to get me started.
>3. Take note of the highest number. (use a select max maybe )
>4. Now modify the table structure again.
>5. Alter the Autoincrement value to the value you noted earlier + 1
>
Yes, I was thinking of doing exactly that.
If it's not broken, fix it until it is.
My Blog