Hi, ok for starters The first thing you need to do is change a few lines.
To open an access DB with code you you will need to specify it as OLEDB
This line:
Quote:
|
Imports System.Data.SqlClient
|
Should be:
Code:
Imports System.Data.OleDB
this line:
Quote:
|
Private database_Connection As New SqlConnection()
|
should be this:
Code:
Private database_Connection As New OleDbConnection()
Next you will need to change this line:
Quote:
|
Dim cmd As New System.Data.SqlClient.SqlCommand(SQL_Statement, database_Connection)
|
to this:
Code:
Dim cmd As New OleDbCommand(SQL_Statement, database_Connection)
That should get you working
.