Update fields in MS Access

database
studio

#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

https://www.tutorialspoint.com/ms_access/ms_access_create_database.htm


#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