[AccessD] Resetting Autonumber seed

Robin Robin at rolledgold.net
Wed May 10 12:28:30 CDT 2006


Gustav,
Read a bit further through this and this is exactly what I need - 

Both the seed and the increment can be modified using an ALTER TABLE
statement. New records inserted into the table will have values that are
automatically generated for the field based on the new seed and
increment values. If the new seed and increment can yield new values
that match existing values generated by the preceding seed and
increment, duplicates will be created. If the field is a Primary Key,
then inserting new records may result in errors when duplicate primary
keys are created. 
The following is an example of using the ALTER TABLE statement to set
new seed and increment values for an auto-increment field:

 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)
Rgds
Robin



More information about the AccessD mailing list