Establish database connection between Visual Studio and Access

%3CLINGO-SUB%20id%3D%22lingo-sub-1484984%22%20slang%3D%22en-US%22%3EEstablish%20database%20connection%20between%20Visual%20Studio%20and%20Access%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1484984%22%20slang%3D%22en-US%22%3E%3CP%3EI%20cannot%20establish%20a%20database%20connection%20between%20Visual%20Studio%20Community%26nbsp%3B2019%20and%20Access.%3C%2FP%3E%3CP%3EI%20get%20an%20error%3A%3C%2FP%3E%3CP%3EThe%20'Microsoft.ACE.OLEDB.12.0'%20provider%20is%20not%20registered%20on%20the%20local%20machine.%3C%2FP%3E%3CP%3EI%20am%20using%20WIndows%2010%20and%20Visual%20Studio%20Community%26nbsp%3B2019%20and%20Access%20as%20part%20of%20Office%20365.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1484984%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Visitor

I cannot establish a database connection between Visual Studio Community 2019 and Access.

I get an error:

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

I am using WIndows 10 and Visual Studio Community 2019 and Access as part of Office 365.

2 Replies
Highlighted

@GordonUSNA 

Maybe you need to install the Microsoft Access Database Engine 2016 Redistributable on the local machine. You can download it at: https://www.microsoft.com/en-us/download/details.aspx?id=54920 

 

Hope this helps.

 

Best wishes,

Tieme

Highlighted
In Microsoft Visual Studio, open a Telerik Report. ...
Choose your Data Connection dialog box appears.
Click New Connection. ...
In the Add Connection dialog box, click Change, in the Change Data Source dialog box, click Microsoft Access Database File, and then click OK.