HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\FilesPathsĬheck if the "mso.dll" registry key is present in both the above paths. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths Go to the registry editor on your desktop (You can search for it in the search bar) and navigate to both the paths below if they exist: Uninstall all the Access driver versions from your machine. If you have 32-bit Office installed on your windows and can't upgrade to 64-bit version of Office, continue reading the rest of the article.įollow the steps below to have both 32-bit and 64-bit Access drivers co-exist on your machine: If you don't see "Microsoft Access Driver" in the list, you need to download and install the 64-bit version either from Microsoft Access Database Engine 2016 Redistributable or Microsoft Access Database Engine 2010 Redistributable. Verify that you have 64-bit Access Database driver installed on your machine by going to ODBC Data Source Administrator (64-bit) application on windows and then the Drivers tab. Kindly note that Power Automate for desktop is based on 64-bit architecture and thus is only compatible to 64-bit database drivers. This error message occurs because the appropriate 64-bit driver isn't installed on your machine. When you use a connection string directly, you may receive the following error message:Ĭan’t connect to data source The '.1x.0.' provider is not registered on the local machine. If you are concerned that Microsoft Access is being phased out then read our recent post on how it continues to be supported and the most widely used database product for small to medium businesses.This article provides a resolution to an issue where you can't establish a connection to Access Database Engine OLE DB in Microsoft Power Automate for desktop.Īpplies to: Power Automate Original KB number: 5004577 SymptomsĬonsider the following scenario in Microsoft Power Automate for desktop:Īccess Database Engine OLE DB provider doesn't show in the Data Link Properties window list when you establish a connection with database actions. The free Microsoft Access Runtime enables you to distribute Access applications to users who do not have the full version of Access installed on their computers.ĭo not install the Access Runtime on a computer that already has the full version of Access installed as this will cause problems. Where to get the Microsoft Access Runtime If you are looking for a DIY fix we detail where you can download the Access runtime versions below. A lot of our work can also help your business use Microsoft Access effectively from home or remotely, using Apps for workers on the move.
At The Access Man, we can help you formulate a range of bespoke Access solutions that help your business work with Access and Office applications effectively, or we can help with supporting and fixing any issues you may have with existing systems. Therefore you can distribute your Access database to as many users as required without needing to purchase additional licences. The Microsoft Access Runtime can be downloaded free of charge from the Microsoft website. How much is the Microsoft Access Runtime? You can use it run an Access database that has been developed on the full version of Access. It is essentially a full version of Microsoft Access without the design tools that let you build new databases. The Microsoft Access Runtime is a version of Access that allows you to distribute Microsoft Access database to uses that do not have the full version of Microsoft Access installed on their computer.