DWUTKA at marlow.com
DWUTKA at marlow.com
Fri Sep 9 13:23:55 CDT 2005
That's it! Drew -----Original Message----- From: Ken Ismert [mailto:KIsmert at texassystems.com] Sent: Friday, September 09, 2005 12:39 PM To: Access Developers discussion and problem solving Subject: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com