[AccessD] Autonumber Duplication????

Charlotte,
 Sorry about that, that is exactly what has started to happen. It's seems
the autonumber field was reset to earlier number, I'm current combing
through my code to see if I caused this.

FE AXP Latest SP/Jet
BE A2K

Robert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, June 01, 2006 5:58 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Autonumber Duplication????

Sorry, but I don't understand.  What data in which field is over 500?
You mean you have autonumbers over 500 and you're suddenly hitting
duplicates of earlier autonumbers?  What version of Access are you running
and what service packs/jet service packs? 


Charlotte Foust

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert
Sent: Thursday, June 01, 2006 2:51 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Autonumber Duplication????

 
Hello All,
 I have run into something that I have not seen before. I have an autonumber
field that has simply started producing duplicate numbers in the 400 range
while the data in the field is over 500..

 The doesn't seem to be any corruption, any ideas??

Thanks
Robert


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