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

Malkannagari, Nikhila 1 Reputation point
2021-06-16T10:01:25.39+00:00

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 for business Windows Server User experience Other
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Leon Laude 86,026 Reputation points
    2021-06-16T10:12:37.483+00:00

    Hi @Malkannagari, Nikhila ,

    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

    1 person found this answer helpful.

  2. Leila Kong 3,706 Reputation points
    2021-06-17T07:00:28.36+00:00

    Hello @Malkannagari, Nikhila ,

    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!

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.