From LotusNotes to MDB

Hello !

I got a problem to write script for migrating data from lotusnotes to MDB file. my exsample script is as you may see below:

My problem is that if my table in MDB file has a additional field and this field's datatype is AutoNumber. when I try to run, it does not add new record to MDB file. But once I remove this Autonumber field, my script can add new record to MDB file.

Can anyone help to advise why it's so ?


 Dim result As New ODBCResultSet
     Dim con As New ODBCConnection
     Dim qry As New ODBCQuery
     Dim temp As String
     Set qry.Connection = con
     Set result.query = qry
     con.connectTo("PDR")
     qry.sql = "SELECT * FROM BOM"
     result.execute
     result.addrow
     Call result.Setvalue("PDRNo", "TEST3")
     result.updateRow
     Set result.query = Nothing
     result.close(DB_CLOSE)
     con.disconnect