Prev: Email Message Text Going in "TO" Field
Next: passwords
From: a a r o n _ k e m p f on 5 Jul 2008 20:02
in SQL Server, you can run TRUNCATE TABLE tblName and it will do this
(just for one table like you want).
I dont' think that this is practical or possible with JET.

But then again-- JET is obsolete, so just move to SQL Server and you
can _DO_ the things you want!

-Aaron


On Jul 4, 10:45 am, VTM3 <V...(a)discussions.microsoft.com> wrote:
> I have created a new table and I noticed that the autonumbering started at 2
> instead of 1.  I deleted the record for 2 and tried to enter data in the next
> field over, and it labeled the first record 3.  I deleted that record and
> started over, but then it labeled the first record 4.  So, how do I get it to
> start over a 1 for the autonumbering primary key column?
>
> Thanks!

First  |  Prev  | 
Pages: 1 2
Prev: Email Message Text Going in "TO" Field
Next: passwords