MS Access database connection


I’m trying to connect to an MS Access database file from uipath. I have downloaded the Uipath.Database.Activities package.

I have a file in my Documents folder, called tickets.accdb.

I’m just trying to do the connect activity.

What do I need to connect? Do I need to run ODBC Data Source Administrator? What format should the ConnectionString and Provider property be in?

Hi @bcm

Look at the below link which may help you for DB connection

Hope this may help you to solve your DB connection query
Mark as solution if this helps you and like it :innocent:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

Hy @bcm,

I hve worked with this package and the Interface it very straight foward. Just a few clicks and you can connect to your database.



Click ok and the select your file, thats it!

Could you please try it and let me know if you have any questions.


1 Like

The ConnectionString property:
“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\ben\Documents\sembo.accdb”

ProviderName property:

Output window gives this message when I try to run Connect activity:
Connect: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.

1 Like


Step: 1 : Click on Configure Connection


Step: 2: Click on Connection Wizard


Step: 3: Click on Microsoft access Database file


Step: 4: Provide your Database file name, Credentials and Test Connection

You are fine to go

Hope this helps


hey, the format of database needs to bee .mdb for your connection.

Please try to save as .mdb your database and try the same connection with Uipath.


Test connection works if I save the access database file as of type *.mdb

But by default MS Access wants to save the file as *.accdb

So, what would be required to make this work with *.accdb?

I think this has to do with microsofts different engines for office. I think this is the road to hell.

Just try this:

Hy @bcm, unfortunattly it is difficul I agree.

I have worked a lot with MS Access connecting with MS Excel, I have always used .mdb and this is the reason why :slight_smile:

Happy Automation

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.