 Access Tables, incrementing tables in access |
|
|
|
|
  |
 May 23 2005, 02:45 AM
Post
#1
|
|
|
Newbie [ Level 1 ]  Group: Members Posts: 7 Joined: 22-May 05 Member No.: 5,317  |
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 below
ALTER TABLE tblImportsRecon ADD COLUMN RowID INT IDENTITY(70000,1) but keep getting a syntax error. This is in an Access 2003 desk-top database. Thanks |
 |
 
|
|
Aug 14 2005, 09:52 AM
Post
#2
|
|
|
Newbie [ Level 2 ] Group: Members Posts: 25 Joined: 7-August 05 Member No.: 7,682 |
You have 70000 records in table?
If yoes, do you can copy your table and empty. Your autoincrement continue. Good luck! |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 13th October 2008 - 04:12 AM |