Skip to main content
Question

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


Forum|alt.badge.img+2
  • Cadet | Tier 2
  • 1 reply

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

Forum|alt.badge.img+1
  • Cadet | Tier 2
  • 5 replies
  • May 18, 2023

Hi @hshtx,

kindly try after changing the Database package version in bots.


jamesmillere
Forum|alt.badge.img

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

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings