Ms access runtime error 3020 plus#
iMaxID is a placeholder for the current maximum value in the field plus 1. AutoNumFieldName is a placeholder for the name of the Autonumber field. TableName is a placeholder for the name of the table. Type the following in the Query1 window:ĪLTER TABLE TableNameALTER COLUMN AutoNumFieldNameCOUNTER( iMaxID,1).Now go to the Design tab, click SQL view in the Results.In the Show Table dialog box, tap to the close option.Go to the Create tab click Query Design in the Other.In order to reset the Autonumber field seed, you can try one of the following methods: Method 1: Use a Data Definition query Open database that has the table in Access 2007. If you see such Security Warning dialog box, then tap to the Open option.