I'm trying to update a field in my MS Access 2016 database but I get the following error when using the output data tool:
Error: Error opening dbschema_primary_keys: Microsoft Access Database Engine: The parameter is incorrect.
I am using the Microsoft Access 16.0 Access Database Engine OLE DB Provider as the connector and have tested the connection as well.
Have checked that the field names and data types in my Select tool and the database table match.
Design view of my Access Table:
Select Tool:
Output Data Options:
I'm stuck at this point having tried altering the data types and also the primary keys in the database. Any help will greatly appreciated.
@NavNav
From the error message, it seems that something wrong with the reading part.
Would it be possible to share the mdb file?
@Qiu, Yes, it could be.
I was able to connect to the file via ODBC and delete all data before appending the full list of updated data again. The update query failed again with ODBC as well because of missing Primary Key.
The forum doesn't seem to allow mdb or accdb files to be uploaded. Any other format that works?