troubleshooting Question

ADODB Connection Visual Basic 2008

Avatar of Jose Bredariol
Jose BredariolFlag for Brazil asked on
Microsoft DevelopmentVisual Basic Classic
3 Comments1 Solution337 ViewsLast Modified:
I´m receiving an error while updating access data base using adodb.
AccessConnect2 = "Driver={Microsoft Access Driver (*.mdb)};" & _
                      "Dbq=dados.mdb;" & _
                      "DefaultDir=e:\dados;" & _
            Conn2.ConnectionString = AccessConnect

            xmat = Rs1.Fields("Matricula").Value
            Xsql = "Select * from " & TextARQ.Text.ToString & " where MAT=" & CStr(xmat)
            Rs2 = Conn2.Execute(Xsql)

            If Not Rs2.EOF Then

                Rs2.Fields("AT").Value = "S"

This update generate an error ..

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros