[AccessD] ADO Access backend Autonumber

hmm, haven't known that to happen (YET) to any of my apps, is someone else deleting records somehow that has access to the BE database ?.  Can the users get access to the BE tables ?


From: "Griffiths, Richard" <R.Griffiths at bury.gov.uk>
Date: Thu 03/Jul/2003 11:36 GMT
To: "'Access Developers discussion and problem solving'"
	 <accessd at databaseadvisors.com>
Subject: RE: [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

_______________________________________________
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.