Access Tables incrementing tables in access

[connectpal 0]

I have several tables that now due to changing business requirements, need to have an auto increments id. However, I need to start incremeitng at 70000, with increments of 1. I wrote the belowALTER TABLE tblImportsReconADD COLUMN RowID INT IDENTITY(70000,1)but keep getting a syntax error. This is in an Access 2003 desk-top database.Thanks

[fabiocardoso 0]

You have 70000 records in table?If yoes, do you can copy your table and empty. Your autoincrement continue.Good luck!