Can I access the large number data type in an Access 2016 file using the Microsoft.ACE.OLEDB provider?

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.

+4
source share

Source: https://habr.com/ru/post/1683325/


All Articles