UPDATING ACCESS 2000 DATABASE BY WAY OF TEXT BOXES USING ADO & SQL

[TNN]

Can anyone Help!
I am creating a recordset using SQL in ADO and then loading the recordset into rows of text boxes by binding the datasource and datafield properties of the text boxes to the recordset. Each row of text boxes is a record.

The question is, How do I update the recordset after making changes to a row of text boxes???? or can I ???

I have tried to: 1. Make the row I edit the current row.
2. Then edit text boxes
3. Then update the recordset
It's not working. I get error that says "Operation requested by app not provided by provider" error 3251 and
rst.update is high-lighted.

I asked this question in the vb forum but no answer as yet.
Can anyone here help?

Thank You,
TNN, Tom
TNPAYROLL@AOL.COM




[sig]<p>TOM<br><a href=mailto:WWW.TNPAYROLL@AOL.COM>WWW.TNPAYROLL@AOL.COM</a><br>[/sig]

 

[TeresaH]

I am having the same problem......

TeresaH@internetcrossing.com
DBA/Programmer

 

[landShark]

try adding the following line before the update:
rst.CursorLocation = adUseClient

let me know how it goes.

 

[TomSark]

You might also try to use a cursor type that is updateable as in a dynamic or keyset cursor (server side). It looks like the type of cursor you are using is not updateable, and therefore, the statement fails...and, if I remember correctly, all client-side cursors in VB, regardless of how you set them, are static cursors.

Tom