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