Chris Kettenbach
chris at piasd.org
Tue Nov 9 11:57:27 CST 2004
excellent. works as anticipated. thanks -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Colby, John Sent: Tuesday, November 09, 2004 9:34 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Unused numbers? That is exactly the way to do it. Max (PK) + 1 inserted back in to the PK field. After that the autonumber should pick up at the next value which will no longer collide. John W. Colby The DIS Database Guy -----Original Message----- From: Chris Kettenbach [mailto:chris at piasd.org] Sent: Tuesday, November 09, 2004 12:19 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Unused numbers? I think something like this has happened. Is there anyway to start it over from the largest value. When users were trying to add new records, it was trying to create duplicate values. I had to go in and use an SQL INSERT. I first did a SELECT Max(NumID) then I did an INSERT with 1+that value. Should the counter begin counting from there now? I hope that corrected the problem. Only way I guess is to try adding a new record. Thanks all. CK -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Colby, John Sent: Tuesday, November 09, 2004 9:02 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Unused numbers? >Maybe it's more trouble than it's worth. And a bad idea. Do you use an autonumber? If so there is no reusing the old numbers. If you try you will reset the counter and the next time the autonumber is used it will collide with values already in the table. Further they are a long integer capable of handling +/- 4 billion values, so why worry about it? John W. Colby The DIS Database Guy -----Original Message----- From: Chris Kettenbach [mailto:chris at piasd.org] Sent: Tuesday, November 09, 2004 11: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 -- _______________________________________________ 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com