> Is there away to reset an auto incrementing field count? I have a > database that currently has 935 records in it but because I have > deleted a few the current number used for NEW records is 938 :) How > can I get it to count the records and assign a record number based on > the total count? > > Hope that makes sense! Thanks for looking! :) > > --
> Jason Pruim > Raoset Inc. > Technology Manager > MQC Specialist > 3251 132nd ave > Holland, MI, 49424 > www.raoset.com > [EMAIL PROTECTED] AFAIK, you need to drop and then recreate the auto-increment field, otherwise you'll get holes when you delete a record. David