7 replies
by yaeerb Accepted solution
by bizzo Accepted solution
by tony hopkinson Accepted solution
there are two properties
one is start value the other increment
They default to 1 and 1, change, em and you are off.
by yaeerb Accepted solution
i looked for this option, but can't find it.
thanx
by tony hopkinson Accepted solution
by yaeerb Accepted solution
there no line that gives you the option to start your own increment.
there must be another way in access 2007.
thanx
by tony hopkinson Accepted solution
SQL stuff.
CREATE TABLE mytable
(
id_num int IDENTITY(300000,3)
)
for instance.
If you script out your current table, it should have IDENTITY(1,1) against the autonumber, twiddle with it then execute (after deleing / renaming the existing one.
I hate access!
This is MS's recomendation or twiddling with autonumbers
This discussion is closed to new replies.
Trending Desktop posts
Sort by Trending