Server Error in '/' Application.

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.

What am I suppose to do with this?

Go to the forum search and search for "updateable query". There are several (dozens) of threads involving this same problem.

Peter

Hi,

This error means that you do not have sufficient permissions to modify the Access database. You must check if the ASPNET user has Modify permissions for the database so your script can work. You can right-click the MDB file, go to the Security tab and check the ACL if the ASPNET user has Modify permissions.

Cheers!


Marlon Villarama
Support Team
Web Burner Hosting
[email protected]
www.webburner.com
Toll-Free: 877-535-2876

Check the connection string statement, no. of paramenters
data source name & server name is entered correctly. To check & more specific, always post with the DB (mdb/SQL/Oracle)

Gokul

There is only one solution to this problem. I spent hours on this.

Right click on the folder that has your access database. Go to security tab, click on add account. Add this Object name COMPUTERNAME\ASPNET. For example, my comp name is ROCK, hence I typed ROCK\ASPNET. Then give this account modify and write permissions.

Problem solved.