SQL statement error

Expand Post »

Hi everybody,

I can't transaction(Insert,delete, and update) to Ms. Access. I use C#(Web Broswer).

This is the message Error:
Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.

Vitou

Similar Threads

SQL statement Error in ASP
is there something wrong with my SQL statement? in PHP
Syntax error in "like" in sql statement in ASP.NET
SQL server error: 18452 - connection to SQL error in Windows NT / 2000 / XP
run sql statement in asp in ASP

vitou85

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since May 2006

Permalink

Jun 7th, 2006

Re: SQL statement error

Quote originally posted by vitou85 ...

Hi everybody,

I can't transaction(Insert,delete, and update) to Ms. Access. I use C#(Web Broswer).

This is the message Error:
Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.

Vitou

Please provide sample code of what you are trying to do, along with more details if you want assistance to this problem.

Are you doing the SQL statement in code? Why not use a standard query in Access to accomplish this task?

Paladine

Team Colleague

Reputation Points: 211

Solved Threads: 27

Master Poster

Offline

793 posts
since Feb 2003

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in ASP.NET Forum Timeline: MP3 to Database

Next Thread in ASP.NET Forum Timeline: How to set User control=false

DaniWeb Message

Cancel Changes

User Name
Password