New AtFixDbfFpt 1.6 can hadle this.

Among other things 08/07/2003 I added Added Autoincrement support and
garbage after last record IN VFP8 added (tnRepairMode = 4) support to the AtFixDbfFpt (downloadable from UT, be sure that you get 1.6 not 1.5a)

Just

DO atfixdbffpt WITH "tmptab.dbf", 4,,,1,.T.,1

AT