Starting Primary Key Value

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 !
 
S

Sal Rosario

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Autonumber field in Excel that behaves the same as Access 0
Auto populate value from one task to another in MS PROJECT 0
Auto Increment for non integer ? 2
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Autonumber as primary key 5
Composite Primary Key with an ID and Index 2

Top