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