USE NewTableWithoutIncFields EXCLUSIVE && To make sure that nobody has access to that table ALTER TABLE NewTableWithoutIncFields ALTER COLUMN AutoIncField SELECT NewTableWithoutIncFields SET ORDER TO ThatFileldThatIsAutoInc GO BOTTOM next_key = AutoIncField+1 ALTER TABLE NewTableWithoutIncFields ALTER COLUMN AutoIncField I AUTOINC NEXTVALUE next_key USE ERASE NewTableWithoutIncFields.BAK * ERASE NewTableWithoutIncFields.TBK If table has MEMO field *COPY or whatever You want to do with it>I send an upgrade that include .exe file and a programa that execute Gendbc from a forder, it create an exactly copy of the database and table structures that I have and make a APPEND FROM, replacing old tables with new ones. Everything have been working fine until I decided to use AutoIncremental fields.