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.