Everything looks fine to me, however, it continuously pops up with errors, tried a few different ways of doing it. Basically trying to get a textbox to write to a db off a website. It keeps popping up an illegal exception error about initialisizing the jet.4.0 driver. Any help would be appreciated.


Dim strSQL As String

Dim myConnection As New System.Data.OleDb.OleDbConnection( _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\AquacultureDB.mdb;") <--Error here so it says


strSQL = "Insert INTO Aquaculture (Facility Name, Facility Location) VALUES ('" & TextBox1.Text & "','" & TextBox2.Text & "');"
myConnection.Open()
myConnection.Close()