[AccessD] Resetting Autonumber seed

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.

-- 
Bryan Carbonnell - carbonnb at gmail.com
Life's journey is not to arrive at the grave safely in a well
preserved body, but rather to skid in sideways, totally worn out,
shouting "What a great ride!"