ASP.NET

SQL statement error

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: May 2006

Posts: 4

Reputation: vitou85 is an unknown quantity at this point

Solved Threads: 0

vitou85

Offline

Newbie Poster

SQL statement error

Jun 7th, 2006

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

•

Join Date: Feb 2003

Posts: 793

Reputation: Paladine has a spectacular aura about

Solved Threads: 27

Paladine

Offline

Master Poster

Re: SQL statement error

Jun 7th, 2006

•

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?

Assistant Manager, Pharmacy Informatics
Wordpress Learning Blog
Updated : ASP.Net Login Code