> 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

Reply via email to