Problem updating database in Visual Basic

Please help, I cant get around the following issue.

I have a program which every form are child forms. In the main midi form i have a save bottom. to add a new record i dont have a problem but i'm not able to update any records. I'm using an Adodc connection with the Microsoft.Jet.OLEDB.4.0 . I use the following line to save my changes..


*******************************************************
Quote.QuoteAdodc.Recordset.Update 'save information to quote database
*******************************************************

Would appreciate a lot if anyone can help me.

How do you update your records?

I have textboxes linked to the adodc control through the datasource and datafield property. I use the following line to update my database.

******************************************************

Quote.QuoteAdodc.Recordset.Update 'save information to quote database

*******************************************************

This command works in other forms i have but not in this particular one. i can open only as read only but i can save the changes i made. I dont get any errors when saving but i"m able to save changes.

Check the mode property of the ADODC control. It might be read-only.

I checked the property the values it has is:

0 - admode unknown

the same as my other forms i event test changing to readwrite but I'm not able to make it accept updates.

try to call the UpdateBatch instead of calling the plain Update method, and
you should switch to ADO object and avoid using data control it is really a pain in the neck.