Hi James, > How do I do above ? I seem to remember reading about how to once before and > the need to delete (?) a file associated with the table. When you restructure the table you can set the Minimum Value for the autoincrement field to your new starting value. Regards, Bevan --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi"