Update fields in MS Access

Help
,
1

Hi,

I want to update fields in Microsoft Access Database.
Thanks in advance.

Regards,
Hemal

2

@ddpadil help me on this.
I am sure you must be having some insights on this query.

Regards.

3

Help me please !

4
5

Hi,

Through UIPATH.

Thanks in advance

6

Use " connect database" activity and configure the wizard. Then use “execute query” activity.

7

Great ! thank you so much :slight_smile:
one more thing, it’s asking me user name and password and i haven’t provided any. So what should I do ?

Thanks,
Hemal

8

I am getting an error like,
the ‘microsoft.ace.oledb.12.0’ provider is not registered on the local machine.
We can solve it in .net through code. But how to solve it in uipath !

Thanks in advance.

9

If anyone gets this kind of issue -
‘the ‘microsoft.ace.oledb.12.0’ provider is not registered on the local machine.’
then he/she needs to install 2007 Office System Driver: Data Connectivity Components.
And I solved it :slight_smile:

Thanks @Henry for guiding in MS Access connection with uipath

Regards,
Hemal

10

Hi Hemal ,
I am facing the same issue with regards to the username and password that it asks when creating access connection how did you get it resolved .

Regards,
Nidhi K

11

Hey @nidhi_K,

I already mentioned the solution. Let me know though if you are not getting.

Thanks & Regards,
Hemal