question

MalkannagariNikhila-6312 avatar image
0 Votes"
MalkannagariNikhila-6312 asked LeilaKong-MSFT answered

will Microsoft access database engine work on Windows server 2016 , provider is Microsoft.ACE.OLEDB.12.0

I have used Microsoft.ACE.OLEDB.12.0 in my code for excel functionality and for it to work I've installed Microsoft Access database engine 2010 32-bit version in windows 2012 R2 server. May I know what else is required for it to work other than this and will it work without any issues when the server is migrated to windows server 2016 which planned very soon

windows-server-2016
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.

LeonLaude avatar image
1 Vote"
LeonLaude answered LeonLaude commented

Hi @MalkannagariNikhila-6312,

The Microsoft.ACE.OLEDB.12.0 is not officially supported on the Windows Server 2016 operating system, this however doesn't mean it may not work, it simply has not been verified/tested by Microsoft, so you'll need to use it at your own risk.

106169-system-requirements.png

Reference:
https://www.microsoft.com/en-us/download/details.aspx?id=13255


If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!


Best regards,
Leon




· 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.

Thanks for the response Leon, Could you please let us know which stable version of Microsoft Access database engine will likely to be compatible with Windows server 2016 and windows server 2012 R2. Also, is it compulsory to have both 32bit and 64bit versions of it to avoid issues.

0 Votes 0 ·
LeonLaude avatar image LeonLaude MalkannagariNikhila-6312 ·

The following one:
Microsoft Access Database Engine 2016 Redistributable

If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!

1 Vote 1 ·
LeilaKong-MSFT avatar image
0 Votes"
LeilaKong-MSFT answered

Hello @MalkannagariNikhila-6312 ,

Just checking in to see if the information provided was helpful.
Please let us know if you would like further assistance.

Please "Accept as Answer" if it helped so it can help others in community looking for help on similar topics. Thanks for your cooperation!

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.