J Joe Jul 24, 2003 #1 Just wondering if anyone out there knows a way to start an autonumber field with 0. Thanks in advance, Joe
Just wondering if anyone out there knows a way to start an autonumber field with 0. Thanks in advance, Joe
K kripesh Jul 24, 2003 #2 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.
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.
T Tim Ferguson Jul 25, 2003 #3 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. Click to expand... "... if you care what the value of an autonumber is, then you shouldn't be using an autonumber..." Tim F
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. Click to expand... "... if you care what the value of an autonumber is, then you shouldn't be using an autonumber..." Tim F
