![microsoft access database engine microsoft access database engine](http://www.softsea.com/screenshot/image/Microsoft-Access-Database-Engine-64-bit.jpg)
MICROSOFT ACCESS DATABASE ENGINE 64 BIT
First thing to check is you installed the 32 bit driver not the 64 bit driver. If none of the above is useful and really want to use the dialog I've shown which you can get to work that can end up being a long and drawn out process. If you look at these examples and have questions feel free to ask. I have a lot of code samples for VB.NET and MS-Access below yet does not cover everything but you should be able to find something e.g. The above code comes from a large code sample you can view online or download. Dim accessOperations As New DataOperationsAccessĭim customersFromAccessDataTable As DataTable =ĪccessOperations.LoadCustomerRecordsUsingDataTable()ĬustomersAccessDataGridView.DataSource = customersFromAccessDataTable Then in a form we can load data from the above code in either form load for forum shown event.
![microsoft access database engine microsoft access database engine](http://2.bp.blogspot.com/-REH5s0L2XNc/U95h51utSYI/AAAAAAAACrk/o-LH7dmgAxc/s1600/Untitled.png)
Using cn As New OleDbConnection With ĬustomerDataTable.Load(cmd.ExecuteReader())ĬustomerDataTable.Columns("CustomerIdentifier").ColumnMapping = MappingType.HiddenĬustomerDataTable.Columns("ContactTypeIdentifier").ColumnMapping = MappingType.HiddenĬustomerDataTable.Columns("ModifiedDate").ColumnMapping = MappingType.Hidden "Cust.ContactTypeIdentifier = CT.ContactTypeIdentifier " "FROM Customers AS Cust INNER JOIN ContactType AS CT ON " & "Cust.PostalCode, Cust.Country, Cust.Phone, Cust.ModifiedDate " & "Cust.ContactName, CT.ContactTitle, Cust.Address AS Street, Cust.City, " & "SELECT Cust.CustomerIdentifier, CT.ContactTypeIdentifier, Cust.CompanyName, " & Public Function LoadCustomerRecordsUsingDataTable() As DataTable Private ConnectionString As String = "Provider=.12.0 Data Source=NorthWind.accdb" Here is an example to read data from MS-Access which in this case joins two tables together (the code logic can be used for one table or several tables).