[AccessD] autonumber

Drew Wutka DWUTKA at marlow.com
Wed Apr 16 05:02:12 CDT 2003


A make table query should already 'reset' the AutoNumber, since it is going
to make a new table. An append query can be used to 'set' numbers within an
AutoNumber field, however, it doesn't reset the counter, it can just
'ignore' it.  If you delete the data in a table, to resent the AutoNumber
counter, compact the database.  It will reset the counter (on an incremental
AN) to the highest number plus 1 (or 1, if there are no records remaining).

Drew

-----Original Message-----
From: John Eget
To: AccessD at databaseadvisors.com
Sent: 4/16/03 4:43 AM
Subject: [AccessD] autonumber

Is there a way to reset the autonumber to 1 of a make table query or an
append or a table I just finished deleting the information from?
John
 <<ATT46269.txt>> 


More information about the AccessD mailing list