Skip to main content

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;

 

Hi @hshtx,

kindly try after changing the Database package version in bots.


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