Converting from SqlClient to OleDb

[Bob Bedell]

Hello,

I converted an ASP web app connected to the SQLClient
namespace to connect to the OleDb namespace. I'm
connecting to a local .mdb file. The only change I made to
the app was importing OleDb vs. SQLClient. The SQL Server
version works great. The Access version gives me the
following error:

"Operation must use an updateable query".

Occurs when using the Update method of the
OleDbDataAdapter. Both the SQL Server and Access apps are
using the Customers table in their respective versions of
the Northwind database.

Any thoughts????

Thanks,

Bob

 

[Bob Bedell]

I don't follow. The Customers table on which the
supposedly non-updateable recordset is based has a primary
key defined. It's just the Northwind database. T^he same
table structure works fine with the SQL Server version of
the app.

-------Original Message-----

 

[Tu-Thach]

Do you have the code for you OleDbDataAdapter? If you
post the part where you create the adapter and update it,
that would help.

Tu-Thach