Accessing Visual FoxPro DBF Files using VB.Net
Posted on 2004-03-30
Hi, I'm writing a program in Vb.Net that will edit data in some Visual FoxPro DBF Tables. I can create the connection without a hitch, however, I cannot generate the update/Add statements for the data table as VB.Net says it cannot identify the primary key for the DBF table. The FoxPro tables are taken from an outside source and as such I can't open them with any other software to try to manually add primary keys to it. I can happily view the table structure so I know what the fields are, and I know which field SHOULD be the primary key field for that table, but I just can't get VB.Net to recognise it as such. Any help or advice you can give me on this would be really helpful, as this is time critical.
Thanks in advance