I am trying to access MS Access database thru odbc connection in ASP.net.
Everything works fine with reading data but it gives error whenever trying
to insert or update as : ERROR [HY000] [Microsoft][ODBC Microsoft Access
Driver] Operation must use an updateable query.
Can anyone please suggest anyting here.
Regards,
Mandar

Hi Mandar,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you are receiving an error "Operation
must use an updateable query" when you're trying to insert or update the
database. If there is any misunderstanding, please feel free to let me know.

Based on my research, this problem might occur because the ASPNET account
does not have sufficient permissions to connect to or write to an Access
database.

Because of security concerns, the ASP.NET worker process runs under the
default ASPNET account. If you do not enable impersonation for an
application, all of the threads that run the requests for that application
run under the process account.

To work around this problem, use one of the following methods:
1. Configure the ASP.NET worker process to run under the SYSTEM account in
the <processModel> section of the Machine.config file.
2. For security reasons, Microsoft recommends that you enable impersonation
on your ASP.NET application. This method works if the impersonated user has
necessary permissions to the computer and the database that you are
accessing.
3. Grant read and write permissions for the "Everyone" group on the
database and the database folder. This method is not safe; therefore,
Microsoft does not recommend this method.

Here is a KB article on this issue:
http://support.microsoft.com/default...B;EN-US;316675

HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

You might try giving read\write permissions for the 'Network Services' account to your ODBC database. This is the account that runs the default app pool on the 2003 server. This should resolve the access problems.

From http://www.developmentnow.com/g/22_2...able-query.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com