关于access自动编号的问题？请指教

Question

table1.insertrecord([Null,1,date,'AA']);表是access表，第一个字段是自动编号，这样插入一个记录，但自动编号会加二，如下所示，有没有办法让自动编号只加一？111 1 2002-12-23 AA
113 1 2002-12-23 AA
115 1 2002-12-23 AA
117 1 2002-12-23 AA
119 1 2002-12-23 AA
121 1 2002-12-23 AA
123 1 2002-12-23 AA
125 1 2002-12-23 AA
127 1 2002-12-23 AA
129 1 2002-12-23 AA
131 1 2002-12-23 AA
133 1 2002-12-23 AA

Answer 1

table1.insert;
table1.fields[1].asinter := 1;
table1.fields[2].asdatatime ;= date;
table1.fields[2].asstring;= 'AA';
table1.post

Answer 2

with ADOQuery1 do
  begin
    Active:=False;
    sql.clear;
    sql.add('select * from tabel1 order by bh');
    Active:=True;
    last;
    append;    FieldValues['bh']:=paramByName('bh').Value+1;
    FieldValues['rq']:=date1;
    ....   
    post;  end;