Hi, I have some deals with this. I can't make this run. It says that "Microsoft.ACE.OLEDB 12.0 is not registered on the local machine". I tried with diferent providers, but still not running. I tried installing the Access Database Engine Driver, and the application seems that don't want to run. What I do then?
Public Sub Home_Form_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Connections = New OleDbConnection("Provider = Microsoft.ACE.OlEDB 12.0;Data Source = C:\Projects\EleccionesFontan\TheGoods.accdb") Connections.Open() Commands = New OleDbCommand("SELECT UserID from TheData", Connections) Adapter = New OleDbDataAdapter() Adapter.SelectCommand = Commands SubTable = New Data.DataTable() Adapter.Fill(SubTable) NameBox.DataSource = ComeData.Tables("TheData").DefaultView NameBox.ValueMember = "UserID" NameBox.DisplayMember = "UserID" End Sub
PS. I'm thinking about translate this to an excel file for run the file and let do the app the magic.
Thanks anyway :-)