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

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-----
>It looks like the OleDb version for Access does not have
>its primary key defined.
>
>Tu-Thach
>
>>-----Original Message-----
>>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
>>.
>>
>.
>

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

>-----Original Message-----
>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-----
>>It looks like the OleDb version for Access does not have
>>its primary key defined.
>>
>>Tu-Thach
>>