Prev: download binary file from website
Next: Compressing/extracting cab file
From: Nitin on 13 Feb 2005 23:20
How can I reset(Start again from 1 after I delete all records from the
table) the 'Seed' of an AutoNumber field in a MS Access database.
Thanx
Nitin


From: Cor Ligthert on 14 Feb 2005 02:56
Nitin,

I thought that this was it.
http://support.microsoft.com/default.aspx?scid=kb;en-us;306287

I hope this helps?

Cor


From: Riki on 14 Feb 2005 03:29
Nitin wrote:
> How can I reset(Start again from 1 after I delete all records from the
> table) the 'Seed' of an AutoNumber field in a MS Access database.
> Thanx
> Nitin

If your table is empty anyway, change it into Number, save, then change it
back to AutoNumber.

--

Riki


From: Paul Clement on 14 Feb 2005 12:24
On Mon, 14 Feb 2005 08:56:38 +0100, "Cor Ligthert" <notmyfirstname(a)planet.nl> wrote:

ý Nitin,
ý
ý I thought that this was it.
ý http://support.microsoft.com/default.aspx?scid=kb;en-us;306287
ý

This *may* work if the table is empty but it isn't reliable.

AFAIK you have to drop the column and re-add it.


Paul ~~~ pclement(a)ameritech.net
Microsoft MVP (Visual Basic)
 | 
Pages: 1
Prev: download binary file from website
Next: Compressing/extracting cab file