[AccessD] ADO Access backend Autonumber

Paul

the user does not have any access to delete records though

Richard

> -----Original Message-----
> From:	paul.hartland at fsmail.net [SMTP:paul.hartland at fsmail.net]
> Sent:	03 July 2003 12:33
> To:	Access Developers discussion and problem solving
> Subject:	Re: [AccessD] ADO Access backend Autonumber
> 
> Richard, 
> 
> Say for example you have records numbered as follows :
> 
> 1001
> 1002
> 1003
> 1004
> 
> if the user deletes record 1002 and another record is added it will look
> like this
> 
> 1001
> 1003
> 1004
> 1005
> 
> The problem with this I have found is that sometimes when you do a compact
> and repair, the autonumber field will get it's knickers in a twist and
> when you add another record it will try starting from 1002 so you will
> then have this :
> 
> 1001
> 1002
> 1003
> 1004
> 1005
> 
> But then it will think that the next number in the sequence is 1003
> because it's just added 1002, and you will of course get errors...I think
> that there is some sort of fix for this somewhere, but can't remember
> where.....
> 
> Paul
> 
> 
> 
> From: "Griffiths, Richard" <R.Griffiths at bury.gov.uk>
> Date: Thu 03/Jul/2003 11:14 GMT
> To: "'AccessD at databaseadvisors.com'" <AccessD at databaseadvisors.com>
> Subject: [AccessD] ADO Access backend Autonumber
> 
> Hi
> 
> Using ADO and Browser interface we have a system that insert records into
> and A97 BE db table which has an Autonumber field - the users do not have
> a
> ui to delete records but we have found 'missing' records ie autonumber
> missed.  Has anyone any experience of this or know of jet/access issues re
> autonumber or any other thoughts.
> 
> Thanks in advance
> 
> Richard
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> __________________________________________________________________________
> Join Freeserve http://www.freeserve.com/time/
> 
> Winner of the 2003 Internet Service Providers' Association awards for Best
> Unmetered ISP and Best Consumer Application.
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com