Hello Stephen,

PrimaryKey is a single field property. You need to use PrimaryKeys for compound indexes.

Check out the "PrimaryKeys: The Primary Keys Fields" section of the devguide... VB.NET example and everything!

Hope that helps,
---J


>I need to write a down and dirty update to an old Paradox system.
>
>The paradox table uses 3 columns for a primary index.
>
>public EdCat1()
>{
>this.TableName = "CHECTLOG";
>this.PrimaryKey = "drawing number+ sheet number+ revision level";
>}
>
>I get an error for the primary key when used this way.
>
>How should I define it.
>
>connection string is here:
>
>add key="EdCat\Connection" value= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\edcat\data;Extended Properties=Paradox 5.x;"
>
>I am sure that it's paradox 4 data.
>
>I do have the BDE installed on this machine BTW.
>