Posted 20 May 2018, 8:46 pm ESTI have Farpoint spread 8.0
I added this control to visual studio toolbox to use it in my C# program.
My OS is windows 7 64bit
I also have office 2013 64bit
I added the following code to my program in the load even of the main form
OleDbConnection connection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\PriceLists\items.accdb;Persist Security Info=False");
OleDbCommand cmd = new OleDbCommand("select * from itemsmain",connection);
OleDbDataReader dr = cmd.ExecuteReader();
DataTable dt = new DataTable();
when I run the program it runs fine and it connects to the access database.
However, when I add the spread control on the form and try to run the program, it gives me the following error message.
System.InvalidOperationException: 'The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.'
Once I remove the spread control from the form, the program runs normally.
Can you help please ?