Not Working Access OLE DB in Visual Studio 2019

Problem

If you are working with the Access Database for your desktop application. You might find the Access OLE DB is not working properly. You can’t access the file through server explorer. However, you can still open the file through the Microsoft Access Application.

Possible Cause

This is because the Access OLE DB driver is not registered by Visual Studio and you should register it.

Solution

• If you want to use Access for your desktop application, you can install the driver here 
• if you want to use Access for your web application, please don’t do that just replace the Access with SQL Server or SQL Lire version