Error: Record is Deleted

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. 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error in midle of routine after it has worked for a few records 5
Add record with ODBC Connection 3
retrieve id of row just created 4
Adding a record to a table 1
Get posted records 3
Record insert/delete anomaly 0
HELP: Using RecordSet.AddNew in a public function 5
dbseechanges error 3622 2

Top