In my .Net application, I use the Microsoft.ACE.OLEDB.12.0 provider to read data from Access files. Everything worked fine until I was faced with the need to read data from a file containing the column type Large Number. ( https://support.office.com/en-us/article/Using-the-Large-Number-data-type-5b623f6e-641d-4e97-8bdf-b77bae076f70 ) I installed the latest database engine ( https: // www.microsoft.com/en-us/download/details.aspx?id=54920 , 32-bit version) and follow the instructions. However, I get the following error when opening a connection to this file:
System.Data.OleDb.OleDbException . 'The database you are trying to open requires a newer version of Microsoft Access.
Is a large quantity supported in the OLEDB provider?
Note. I also tried using the Microsoft.ACE.OLEDB.16.0 provider (the instruction says to use 12.0) and got the same results.
Note 2: I tried using the latest version of Database Engine 2010. Same problem.
source
share