TadoTable and Primary Key with Multi fields : Edatabase Error : Duplication in TIndexDefs
Posted on 2010-08-30
I have a MSAccess DataBase
And in this DataBase a Table with a Primary Key based on 2 fields (NumField1 and NumField2). This table is in fact linked with 2 mothers tables (one with NumField1 Field and the other with Numfield2 Field)
In delphi i use a TadoConnection to connect my database (witj odbc driver)
I use too a TadoTable to connect my table and i don't add or specify Index
At compilation no pb.
When i execute my application i have a Edatabase error : my <Primary Key Name > is duplicate in TIndexDefs.
I tried many things and i am sure it's because i have a multi fields in my primary index in access but i don't understand why it's no walk with Tadotable in Delphi.
Thanks for your help