G Geoff Jones Dec 9, 2004 #1 Hi How do I set the starting value of an autoincrementing primary key? Thanks Geoff
L Lynn Trapp Dec 9, 2004 #2 1. Run the following insert query. INSERT INTO YourTable (YourAutoNumberField) Values (1000); 2. Open the table and delete that record you just inserted. 3. The next created record will have a value of 1001. Obviously, you need to replace 1000 with the value that is one lower than where you want it to start.
1. Run the following insert query. INSERT INTO YourTable (YourAutoNumberField) Values (1000); 2. Open the table and delete that record you just inserted. 3. The next created record will have a value of 1001. Obviously, you need to replace 1000 with the value that is one lower than where you want it to start.
