Drew Wutka
DWUTKA at marlow.com
Thu Apr 17 04:54:46 CDT 2003
Actually I knew that...somewhere in the back of my mind....but since I do mostly 97 stuff, I tend to ignore the philanderings of it's offspring! <grin> Drew -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Wednesday, April 16, 2003 6:35 PM To: accessd at databaseadvisors.com Subject: RE: [AccessD] autonumber FYI, this doesn't work in A2k or AXP with Jet 4 SP 4 or above. The counter does not get reset to the next highest number when you compact. They fixed it in O2k SR-1 and broke it again in the Jet service packs. Charlotte Foust -----Original Message----- From: Drew Wutka [mailto:DWUTKA at marlow.com] Sent: Wednesday, April 16, 2003 2:02 AM To: 'AccessD at databaseadvisors.com ' Subject: RE: [AccessD] autonumber 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>> _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com