For access connection with uipath but not update the row field

Help Activities
,
1

connect to database
connection string
“Dsn=MS Access Database;dbq=C:\UI PATH FOLDERS\accdata.accdb;defaultdir=C:\UI PATH FOLDERS;driverid=25;fil=MS Access;maxbuffersize=2048;pagetimeout=5;uid=admin”
provider name
“System.Data.Odbc”
database connection
“database”
run query for read the data in file
existing connection
“database”
SQL query
“Select * From Ddata”
output datatable
“DT_table”
but for update a row item i use run query
existing connection
“database”
SQL query
“Update Ddata set Status = ok where ID = 1”
error is
“run query: error [07002] [microsoft][odbc microsoft access driver] too few parameters. Expected 1.”

for update the query update is not work please help

3

Hey @Simple_Works
The error you’re getting, “[07002] Too few parameters. Expected 1”, usually means Access can’t find a field - often due to a typo.
First, double-check the field names (Status and ID) to make sure they’re correct and match exactly what’s in your Access database. Access is picky about exact matches.

Also, if “Status” is a text field, it needs quotes:
Update Ddata set Status = 'ok' where ID = 1

Lastly, test the query directly in Access to confirm that it works, as sometimes Access treats fields as parameters if there’s an issue.

Let me know if this helps!

4

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