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
qry.sql = "SELECT * FROM BOM"
Call result.Setvalue("PDRNo", "TEST3")
Set result.query = Nothing