[AccessD] Resetting Autonumber seed

Hi Bryan

You mean ALTER COLUMN?

/gustav

>>> carbonnb at gmail.com 11-05-2006 03:21 >>>
On 5/10/06, Robin <Robin at rolledgold.net> wrote:

>  ALTER TABLE TableName ALTER COLUMN FieldName SET IDENTITY (2,4)
>
> Are you thinking I can't do this because I'm using Acess97 ?
> (I've tried sbstituting IDENTITY for COUNTER but get the same error)

The problem is ALTER TABLE is part of the DDL SQL Syntax, which is not
supported in A97.