CODEWITHSUNDEEP
c#ms-accessoledb
Liza
Liza

Reputation: 51

Can I access Large Number data type in Access 2016 file using Microsoft.ACE.OLEDB provider?

In my .Net app, I use a Microsoft.ACE.OLEDB.12.0 provider to read data from Access files. Everything had been working fine, until I faced the need to read data from file containing Large Number column type. (https://support.office.com/en-us/article/Using-the-Large-Number-data-type-5b623f6e-641d-4e97-8bdf-b77bae076f70) I've installed the latest Database Engine (https://www.microsoft.com/en-us/download/details.aspx?id=54920 , 32-bit version) and followed the instructions. Still, I'm getting next error when opening the connection to that file:

System.Data.OleDb.OleDbException: 'The database you are trying to open requires a newer version of Microsoft Access.'

Is Large Number supported in OLEDB provider?

Note: I've also tried using Microsoft.ACE.OLEDB.16.0 provider (instruction tells to use 12.0) and got same results.

Note 2: I've tried using the latest release of Database Engine 2010. Same problem.

Upvotes: 4

Views: 595

Answers (1)

Liza
Liza

Reputation: 51

Update: I've gotten an answer from MSFT CSG, you can view it here: https://social.msdn.microsoft.com/Forums/office/en-US/c314519b-d972-43ac-9a04-29cae19413b8/can-i-access-large-number-data-type-in-access-2016-file-using-microsoftaceoledb-provider?forum=accessdev

TLDR: As of 8 Aug 2017, the component (aceoledb.dll) does not support Large Number data type.

Upvotes: 1

Related Questions