[AccessD] ADO Access backend Autonumber

No I don't think users have access - even if they did there is no reason to
go in and find one record out of many 1000's and delete - there has to be a
more logical answer I think
Richard

> -----Original Message-----
> From:	paul.hartland at fsmail.net [SMTP:paul.hartland at fsmail.net]
> Sent:	03 July 2003 12:52
> To:	Access Developers discussion and problem solving
> Subject:	Re: RE: [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.
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com