John W. Colby
jcolby at ColbyConsulting.com
Wed Apr 16 21:10:28 CDT 2003
For my money, it was always a PITA anyway. I prefer that it doesn't reset. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Wednesday, April 16, 2003 7: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 ----------------------------------------------------- eMailBoss puts you in command of your email. Get your copy today at http://www.eMailBoss.com -------------- next part -------------- A non-text attachment was scrubbed... Name: winmail.dat Type: application/ms-tnef Size: 2532 bytes Desc: not available URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030416/daacecd8/attachment-0001.bin>