Hello
I am trying to connect to an online MS Access database and then import simple data into it via an online form.
I have Imports System.Data.OleDb in my ASP.NET (vb file). I am getting this error:
Line 29: myMDBConnection = New OleDbConnection _
BC30188: Declaration expected (but I have declared it).
The rest of my brief code looks like this (thanks for reading):
Partial Class Account_Register Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, _ ByVal e As System.EventArgs) username.Focus()
End Sub
Dim myMDBConnection As OleDbConnection
myMDBConnection = New OleDbConnection _ <<<<--------ERROR
("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myDatabase.mdb;")
myMDBConnection.Open()
myMDBConnection.Close()
Protected Sub CreateUser_Click(ByVal sender As Object, ByVal e As System.EventArgs)
...
Go to the complete details ...