Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.
Question
How do i close a connection after using .addnew?
Hi, I've got some code which add's all the data on a form and sends it to a mysql database. it's as follows:
rsDB.Open "select * from allusers", DBConn, adOpenForwardOnly, adLockOptimistic
rsDB.AddNew
With rsDB
.Fields("user") = Text1.Text
.Fields("company") = Text2.Text
.Fields("address") = Text3.Text
.Fields("phonenumber") = Text4.Text
.addnew
end with
rsdb.close
when i try to close it, it says "Operation not allowed in this context" (Run time error '3218')
how do i close the item so other forms in the app can do there thing?
Solution
About this Solution
View This Solution - Start Your 30 Day Free Trial- Zone
- general
- Tags
- Participating Experts
- 5
- Solution Grade
- A
Posted on 2003-05-29 at 17:00:17ID: 35610421
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.