AddNew Error in table

[illy2k]

I am trying to setup a handheld barcode scanner which sends its data into an Access database table. I have the Dolphin 7200 by HHP, and the program I am using is ITScriptNET Batch. The program has an automatic way to setup the collectin of the data so that it goes to an access table. You specify database and then table, and you can assign different prompts on the handheld to go into certain fields in the db. However when I try to sync the data and get it into access I get this error:

Number 80040e21 Update or CancelUpdate without AddNew or Edit.[Microsoft Jet Engine Database]

I don't know if anyone has any experience with this program, but it is supposed to integrate with access and I didn't think there was anything else you needed to do except make sure you pointed it to the right table and db. Any help would greatly be appreciated.

 

[llkhoutx]

spund like you need to execyyte a rs.addnew or rs.eduit immediatlely before stuffing the barcode.

Of course it should them be following with a rs.update.

 

[illy2k]

fixed

thanks for the advice, but it was actually a data incompatability. I was trying to stuff a field in the table with something bigger than the max field size in the table. I fixed the problem and all works fine now.