Autonumber Starting at 0 (Zero)

[Joe]

Just wondering if anyone out there knows a way to start an
autonumber field with 0.

Thanks in advance,
Joe

 

[kripesh]

refer the foll. artilcle:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;812718

Im using access 2002. I got it right when I used 0 in the
table copy of the table instead of 0 as mentioned in
article.

 

[Tim Ferguson]

You can delete all the records and then use RunSQL to
insert 0 into the autonumber field. The problem is that
this works well in PC running on Windows 2000 but does not
work in Windows 2002 Professional XP.

"... if you care what the value of an autonumber is, then you shouldn't be
using an autonumber..."


Tim F