[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