[AccessD] URGENT - Autonumber is Creating Duplicate Numbers

I believe thats a bug that has been solved in x or z service pack...

	-----Oorspronkelijk bericht-----
	Van: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] Namens
paul.hartland at fsmail.net
	Verzonden: maandag 13 oktober 2003 16:15
	Aan: Access Developers discussion and problem solving
	Onderwerp: Re: [AccessD] URGENT - Autonumber is Creating
Duplicate Numbers
	
	

	Although I can't think how I resolved this issue in the past, I
had it happen quite a few times.  What was happening was records we're
being deleted thus leaving gaps in the autonumber field like so

	100001

	100003

	and sometimes when the database was compacted, and a user tried
to make a booking, it would use 100002 and would allow them to complete
& save the booking, but then it would think that the next number in
sequence was 100003 and get the same error as yourself.....I'll try and
look how I resolved this

	Paul Hartland
	
	
	
	

		Message date : Oct 13 2003, 03:10 PM 
		From : Terri Jarus 
		To : accessd at databaseadvisors.com 
		Copy to : 
		Subject : [AccessD] URGENT - Autonumber is Creating
Duplicate Numbers 
		
		
		
		


		My Autonumber is creating duplicate number.  Of course, 
		the records aren't being saved as the Autonumber needs
to be unique.  What 
		should I do and why is this happening?

		 

		Thanks for any help you can give.

		 

		Terri Jarus
		Director, Contract Support Services
		
	
href="mailto:jarus at amerinet-gpo.com">jarus at amerinet-gpo.com
		314-542-1902











	
------------------------------------------------------------------------
---
		
		This email and any files transmitted with it are
confidential and
		
		intended solely for the use of the individuals or
entities to whom they
		
		are addressed. If you have received this email in error
please return 
		
		it to the sender, and erase any copies thereof.
		
		
		
		Copyright 2003 AmeriNet 1nc. 




		[ (no filename) (0.2 Kb) ]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031013/791230a6/attachment-0001.html>