Skip to main content
Question

define a primary key for a Access Datenbank before Writting

  • February 6, 2023
  • 1 reply
  • 166 views

arash_hokm
Contributor
Forum|alt.badge.img+8

Hello FME Community,

I want to create an access database from my tables.

When creating the database, some columns must be defined as primary keys. I want to know how can I define column in FME as primary key before writing.

 

 

1 reply

saraatsafe
Safer
Forum|alt.badge.img+9
  • Safer
  • February 10, 2023

Hi @arash_hokm​, you can do this either in your writer or by using a FeatureWriter. In either case, go into the parameters and then into the User Attributes tab. You can then use the Index column to set the attribute you'd like as PrimaryKey. You can find more detail in this article. I hope this helps!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings