Question

Trying to connect to MS Access DB and get error: Could not Connect to Database. Could not find installable ISAM.


Badge +2

Hello,

I am trying to connect to a MS Access database which is password protected. When I try to run the bot, I get the below error:

The connection string is:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\xuser\Documents\RPA_Notes\AA Practice\DB to Excel to App\TestDBPwd.accdb;JetOLEDB:Database Password=testtwdb;

 


2 replies

Badge

Hi @hshtx,

kindly try after changing the Database package version in bots.

Badge

Hi,
This type of error typically occurs when there is an issue with the connection string or the required components for connecting to the MS Access database is not installed.

Well, follow these steps to get it done -

  1. Check the Connection String
  2. Install the Required Components: Like "Microsoft Access Database Engine" or "Microsoft Office" needs to be installed. If these components are missing or not installed correctly, it can result in the "Could not find installable ISAM" error.
  3. Update the Connection Provider

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\xuser\Documents\RPA_Notes\AA Practice\DB to Excel to App\TestDBPwd.accdb;JetOLEDB:Database Password=testtwdb;

  1. Verify Database Password
  2. Test Connection Outside of the Bot

 

Reply