[AccessD] Resetting Autonumber seed

Hi Robin

The author tries to tell you that you can remove (delete) the autonumber field and all its relations and recreate these - not exactly what you want.

/gustav

>>> Robin at rolledgold.net 10-05-2006 19:09:31 >>>
Thanks Gustav,
Reading the 'Alter Table' section seem to agree with you - then I saw
this ?

'As a side note (and in addition) to changing field data types or
changing the seed and increment value of an Auto-increment data type,
the programmer can also drop fields and constraints. '

But I can't decipher the syntax to see how it can be done...

Rgds
Robin



-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: 10 May 2006 18:08
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Resetting Autonumber seed


Hi Robin

It doesn't look so:

  http://support.microsoft.com/kb/q275561/ 

This article describes the new features of Microsoft Jet 4.0, and the
article also compares some of the changes between Microsoft Jet 3.5 and
Jet 4.0.

/gustav


>>> Robin at rolledgold.net 10-05-2006 18:37:10 >>>
Thanks Marty - 
The line wrap is just in Outlook - viewing strsql gives the intended
line ... Does anyone know if the syntax is valid - checking help in
Access 97 doesn't give the "counter" option Rgds Robin