The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

Mahdi Elahi 31 Reputation points
2022-07-13T07:40:12.043+00:00

i have to db context in my project 1.Sqlserver 2 . Access

i run add-migration -context AccessDbContext and migrations created successfully

but when i run update-database -context AccessDbContext , i have this error :

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

i have office 2013 in my system.

Developer technologies | .NET | .NET Runtime
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff
    2022-07-14T01:11:21.087+00:00

    Hi @Mahdi Elahi ,
    Try to install the following components.
    Microsoft Access Database Engine 2010 Redistributable
    Best Regards.
    Jiachen Li

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


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.