Problem updating database in Visual Basic

Riem2k
10-21-2004, 09:01 AM
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.

rufen101
10-21-2004, 09:25 AM
How do you update your records?

Riem2k
10-21-2004, 09:32 AM
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.

rufen101
10-21-2004, 10:18 AM
Check the mode property of the ADODC control. It might be read-only.

Riem2k
10-21-2004, 10:37 AM
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.

Dennis DVR
10-21-2004, 09:17 PM
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.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum