question

sakuraime avatar image
0 Votes"
sakuraime asked SaurabhSharma-msft edited

Azure data factory : Linked Service MIcrosoft Access

May I know what's the minimum support version of Microsoft Access for this linked service from Azure data factory .?

azure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

anyone has the idea ?

0 Votes 0 ·

anyone has the idea ?

0 Votes 0 ·
KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered SaurabhSharma-msft converted comment to answer

Hi @sakuraime,

Apologies for the delayed response and thanks for your query and using Microsoft Q&A forum.

As per the official documentation Microsoft Access 2016 version of ODBC driver doesn't work with this connector. IT is recommended to use driver version 2013 or 2010 instead. Hence 2010 is the minimum version required.

116981-image.png

Hope this info helps. Do let us know if you have further query.



Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.



image.png (27.7 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

it only talks about driver version , not Microsoft Access version.

0 Votes 0 ·
SaurabhSharma-msft avatar image
0 Votes"
SaurabhSharma-msft answered SaurabhSharma-msft edited

@sakuraime As per internal discussion it is recommended to use 2013 access version as it doesn't work with 2016 version of Access database engine and 2010 is no longer suggested as a recommended solution. Wording in the document looks confusing and we are internally working to update the documentation. Hope this helps.

Please let me know if you have any other questions.

Thanks
Saurabh

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

so where can I find the support matrix for driver 2013 ?
thanks

0 Votes 0 ·

@sakuraime sorry but what kind of matrix you are looking for ? We are internally working to update the documentation with 2013 Access version. I can internally share the information are looking so that it could be addressed through the documentation.

Thanks
Saurabh

0 Votes 0 ·