Thursday, May 7, 2020

Connect to MS Access From .Net FrameWork Application

Note that this required a .Net Framework Application. When Microsoft brought out .Net Core, they stop supporting OleDb

Imports System.Data.OleDb.OleDbConnection
Module Module1
    Sub Main()
        Dim connStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\CIM_CourseDevelopment\BillOfMaterial.accdb; Persist Security Info=False"
        Dim cnn As New OleDb.OleDbConnection(connStr)
        Try
            cnn.Open()
            Console.WriteLine("Connection established")
            Console.ReadLine()
            cnn.Close()
        Catch ex As Exception
            Console.WriteLine(ex.Message)
        End Try
    End Sub
End Module

No comments:

Post a Comment

OneNote Math Operations

  Supported arithmetic operators Operator Meaning Example +  (plus sign) Addition 3+3 -  (minus sign) Subtraction Negation 3-1 -1 *  (asteri...