Starting Primary Key Value

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Can anyone tell me how I would define a primary key that I
want to begin at a particular number... for example...
starting at:

2066 and incrementing
2067
2068
2069... etc.

Thanks !
 
You can run the query below. Then delete that record from the table. The new
records will start at 2066. NOTE: Make sure you do not Compact and Repair
before you enter at least the first record. Otherwise, everything will go
back to start at 1.

INSERT INTO YOURTABLENAMEHERE (YOURAUTONUMBERFIELDNAMEHERE) Values (2065)

Sal
www.cedrostec.com
 
Back
Top