Last post Nov 29, 2009 05:22 PM by tugberk_ugurlu_
Nov 29, 2009 04:15 PM|tugberk_ugurlu_|LINK
Hi. I am using MS Acces for my DBs and I would like to make the Primary key and ID which are the same start from a specific number. We can do that in mdf file but now mdb. At least I couldn't do that. Help folks !
Nov 29, 2009 05:00 PM|Mikesdotnetting|LINK
So long as your table is new and totally empty, you can force the Autonumber to start with any value you like just by running an Insert command which includes your Autonumber field:
Insert into MyTable(PrimaryKeyField, field2, field3..) Values (10000, 'val2', 'val3'....)
Nov 29, 2009 05:14 PM|tugberk_ugurlu_|LINK
I will try it now. Thanks a lot !
Nov 29, 2009 05:22 PM|tugberk_ugurlu_|LINK
Perfect ! It works smothly :) Thanks a lot :)