Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Error 3219 "operation not allowed" after ADO data grid updated

Status
Not open for further replies.
AMHCLH

AMHCLH

Programmer
Nov 26, 2002
23
US
I am updating my programs to use ADO. I have bound my ADO recordset to a datagrid and allow the recordset to be updated automatically. The problem is after an update in the grid- the next time I try to close the recordset and open it for another select, I get error 3219 "operation not allowed in this context". I added code found in this forum
If rst2.State = adStateOpen Then rst2.Close

but I still get the error on the rst2.close. The rst2.State value comes back as one, but it won't close the recordset. Any ideas?
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
checkbox on msflex grid 3
Replies
8
Views
724
VB6-Programming
VB6-Programming
Swi
  • Locked
  • Question
API - multipart/form-data
Replies
3
Views
328
Swi
Swi
Niki_S
  • Locked
  • Question
Error in Excel/VB6 function: "Constant expression required"
2
Replies
31
Views
511
strongm
strongm
Niki_S
  • Locked
  • Question
How to insert data into a grid by using another grid in vb 6?
Replies
2
Views
115
Andrzejek
Andrzejek
R_a_i_n_e_r_8
  • Locked
  • Question
Compile error: Types of intolerance (need help)
Replies
3
Views
412
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top