Joe Hecht
jmhla at earthlink.net
Wed Nov 10 21:15:56 CST 2004
It is more trouble. Rarely if ever do you want to reuse a primary field value. JOE HECHT LOS ANGELES CA jmhla at earthlink.net -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Chris Kettenbach Sent: Tuesday, November 09, 2004 8:39 AM To: accessd at databaseadvisors.com Subject: [AccessD] Unused numbers? I have an autonumber table of like 13000 records. Does anyone have any sample code to loop through the primary key field and find the numbers that are missing? Basically reuse old primary keys of deleted records. Maybe it's more trouble than it's worth. Thanks All!! CK -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com