I am creating a query from Snowflake and want to write the results to a Microsoft Access database. The job fails when writing to Access with the following error: Microsoft Access Writer: Writer mode for feature type `tblDaily' requires key column specification, or a where clause specification. I have searched on line and can't find a good example of how to correct this error. Can you point me in the right direction? Thanks!
Question
How can I create a primary key so Microsoft Access Writer won't throw an error?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Can you post a screenshot of your Access table definition as well as the FME output feature type?
+26- Evangelist
It sounds like the Writer it set to write in Update Mode. In order to match a Feature to an existing Database Record and update a field's attributes, FME needs to know what the Key Identifier field(s) are to match with (or an equivalent WHERE clause that states a way to match the Features to the Table being updated to like WHERE FMEResultKeyIDAttribute = AccessDBKeyIDField
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.