[AccessD] Reset Autonumber (WAS: Autonumber Assigned Immediately)

I use a Data-Definition SQL statement:

ALTER TABLE TableName ALTER COLUMN AutoField COUNTER (1,1); 

The first number is the starting value, and the second is the increment.

This works for A2K and later.

-Ken

>> Remind me in the morning, but I know there is a 
>> property within an ADO recordset, that if you 
>> remove all the records, you can 'reset' the 
>> Autonumber (the property is the 'next' number, 
>>> if I remember correctly....)

>> Drew