[AccessD] Autonumber problem

To be quite honest, I do not use random autonumbers but it seems that 
the entire question is moot since you don't have "holes" anymore.  How 
the random generator decides that a number is not already used is beyond 
me, but I assume that it checks.

John W. Colby
www.ColbyConsulting.com


Heenan, Lambert wrote:
> Just out of curiosity, does the manual method of resetting the autonumber
> seed handle tables where the autonumber is random instead of sequential -
> like in a replicated table?
> 
> Lambert 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> Sent: Tuesday, May 20, 2008 9:37 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Autonumber problem
> 
>  > The moral being your mileage may vary.
> 
> Yup.  However the fact that this happened at all says that somewhere the bug
> is striking again.  Either there is an unpatched workstation being used to
> C/R the database BE or the bug has resurfaced, which wouldn't surprise me.
> 
> BTW, it does not have to do with the BE container revision - 2k, 2k3 etc.
> It was a known bug in the C/R itself, thus almost certainly a bug in JET.
> 
> John W. Colby
> www.ColbyConsulting.com
>