Accessing Paradox Tables From C# Using ODBC

[Steve Barker]

I am trying to access Paradox through a .NET Windows application I am
writing. I have added a Data Connection to the Paradox table in the Server
Explorer of Visual Studio .NET. I have used the "Microsoft OLD DB Provider
for ODBC Drivers" option to make the connection. This works fine... even
though the Paradox table is password protected. I have dragged a the table
from the Server Explorer to my form to make a connection object and a data
adapter. I have also generated a data set from the data adapter. Now, I can
use the data adapter to fill an instance of the data set with no problems. I
noticed though that the data adapter's UpdateCommand, DeleteCommand and
InsertCommand properties are null, so I've created these objects using an
OdbcCommandBuil der. When I try making changes to the data set, and use the
Update method of the data adapter, I get an error! The error is as follows:

System.Data.Odb c.OdbcException : ERROR [HY000] [Microsoft][ODBC Paradox
Driver] Operation must use an updateable query.\r\n at
System.Data.Com mon.DbDataAdapt er.Update(DataR ow[] dataRows, DataTableMappin g
tableMapping)\r \n at System.Data.Com mon.DbDataAdapt er.Update(DataS et
dataSet, String srcTable)\r\n at
System.Data.Com mon.DbDataAdapt er.Update(DataS et dataSet)\r\n at
ParadoxTest2.Fo rm1.Form1_Doubl eClick(Object sender, EventArgs e) in
c:\\visual studio .net\\c#\\parad ox test 2\\form1.cs:lin e 165

Anyone got any ideas why this is happening?!

Thanks in advance for your help!

Steve.