Hi everybody, i just registered here.
Hoping to learn some from everything i find here and also hoping a bit to be helped out.

I am creating a small program which has a few texboxes which i want to saved in a access database.
My problem is i have no clue what code belongs to such button.

I have added the database to my datasources, and linked the fields from the database to the textboxes.
But thats all i got so far,.
Being searching around the net for a few days to figure this out, but no luck.

So i am kinda hoping to find some help here for this.

in my access db i got the fields firstname, surename, address1, address2, postcode, phone, email.
Each are linked to their matching textbox on the form.
Surname.text - surname
Firstname.text - firstname

I was trying this, but its giving me a error saying "Unrecognized database format..."

Dim formConn As OleDb.OleDbConnection = New OleDb.OleDbConnection
            formConn.ConnectionString =
            "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Administrator\Documents\Visual Studio 2010\Projects\Prijsmaken - DB\prices.accdb;"
            Dim formCommand As New OleDb.OleDbCommand("Insert into CustomerInformation (FirstName) Values ('" & Me.TxtSurname.Text &
        Catch ex As Exception
            MsgBox("Error: " & ex.Message)
            If formConn.State <> ConnectionState.Closed Then
            End If
        End Try

Ah i figured it out, its Microsoft.ACE.OLEDB.12.0 now.

however when i use that code it says "Error: could not find output table 'Surname'

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.