Last post Apr 18, 2014 12:14 PM by Den Solis
Jan 27, 2010 09:09 AM|krishyy|LINK
Would any one can help me how to set the autonumber value with one starting value?I want to start the autonumber from 720 for ID field in my table..
Jan 27, 2010 09:23 AM|hans_v|LINK
Jan 27, 2010 09:24 AM|JayChapani|LINK
hope this may help you
Jan 27, 2010 09:50 AM|krishyy|LINK
I tried that method but not working..
Mar 17, 2010 01:40 AM|KumarHarsh|LINK
It is possible,
Create a table in msaccess namely Table1 with
Save and close
Now in msaccess's query,
ALTER TABLE [Table1]
ALTER COLUMN [id] COUNTER (720,1)
Open Table1(not design) again,
insert records in fname,
wht do you observe ?
Mar 27, 2010 02:33 AM|KumarHarsh|LINK
Did the problem solved ?
Apr 18, 2014 12:14 PM|Den Solis|LINK
This work for me. I did note that I had to actually try to enter a new row before I saw the new number.
Thanks for the tip.