Updating Rows in AccessDB: Error

[ConnorM]

I'm trying to update row information in an access database however, continue to get the following error after ensuring my input data matches the formats access is expecting. This occurs for any "Update;" choices in output options.

"Error: Output Data (57): Error opening dbschema_primary_keys: Microsoft Access Database Engine: The parameter is incorrect."

From my interpretation this is an issue with reading the primary keys however, unsure how to go about a solution. My primary key is an autogenerated number, I'm pulling and then including this number in my update workflow.

I'm able to read via input tool the entire DB and write new rows using the "Append Existing" output option.

[danilang]

HI @ConnorM 

If your inserts are working, check the format of the primary key field that your using in your updates.  There also an other option that you can look at where the solution writes to staging table and then calls a post sql to update the main table.

Dan