troubleshooting Question

Update access database problem

Avatar of brillox
brilloxFlag for United Kingdom of Great Britain and Northern Ireland asked on
Visual Basic.NET
30 Comments1 Solution226 ViewsLast Modified:
Hi,

I was able to display the data from the clients ACCESS table in VB.NET. I have a OleDbDataAdapter configured with the select insert update and delete statemetn, I have my dataset etc.

all data are displayed in texboxes binded to the dataset in the VB.NET form

I have a button with this code

 Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
        Try
            Me.OleDbConnection1.Open()
            OleDbDataAdapter1.Update(DsEditClients1)
            MsgBox("Update executed successfully", MsgBoxStyle.Information < "Update success")

        Catch updateException As System.Exception
            MsgBox("Update failed, please check source code", MsgBoxStyle.Critical, "Update Error")

        Finally
            Me.OleDbConnection1.Close()
        End Try

    End Sub

the error message is displayed......   WHy ??

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 30 Comments.
Join the Community
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 30 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