S
SAC
I'm adding records to a sql table using ODBC and several records add
successfully, but then in the middle of the code I get a "Record is Deleted"
error.
Here's the code idea:
Dim lngCounter as Long
Dim db as database
Dim rs as recordset
set db = currentdb
set rs = db.openrecordset("Orders", DbOpenDynaset, dbSeeChanges)
Do....
rs.addnew
lngCounter = lngCounter +1
rs!key = lngCounter
....
rs.update
rs.Movenext
loop
This occurs on a line between rs.addnew and rs.update.
I have the dbSeeChanges option set when I set the rs.
I'm incrementing a Long variable to set the Primary key field.
Any ideas?
Thanks.
successfully, but then in the middle of the code I get a "Record is Deleted"
error.
Here's the code idea:
Dim lngCounter as Long
Dim db as database
Dim rs as recordset
set db = currentdb
set rs = db.openrecordset("Orders", DbOpenDynaset, dbSeeChanges)
Do....
rs.addnew
lngCounter = lngCounter +1
rs!key = lngCounter
....
rs.update
rs.Movenext
loop
This occurs on a line between rs.addnew and rs.update.
I have the dbSeeChanges option set when I set the rs.
I'm incrementing a Long variable to set the Primary key field.
Any ideas?
Thanks.