|
| ASP.net and Dreamweaver 8: Operation must use an updateable query |
 |
Wed, 4 Apr 2007 17:15:30 +0000 |
Greetings: Platform: Windows Server 2003 Application: Dreamweaver 8 I am
deploying an ASP.net application using Dreamweaver 8. Upon submission of the
online form, I receive the following error listed three (3) times:
System.Data.OleDb.OleDbException: Operation must use an updateable query. at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object&executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object&executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object&executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior,
String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at
DreamweaverCtrls.DataSet.DoInit() I have read posts regarding permissions on the
database. How exactly does one go about setting the permissions to allow updates
to the database. What are the exact permissions necessary? Are there any other
thoughts on the above error? Thanks a lot.
|
| Post Reply
|
| Re: ASP.net and Dreamweaver 8: Operation must use an updateable query |
 |
Thu, 5 Apr 2007 07:28:36 +0000 |
The exact permissions are Modify, and they should be given to the ASPNET
account, although on Windows Server 2003, it is probably the NETWORK SERVICE
account.
Right click on the folder containing the Access database, then choose Properties
| Security. Click "Add". Click "Advanced" and make sure
the "From this location..." entry matches the current box. Click
"Find Now" and you will be presented with a list of user accounts.
Double click the NETWORK SERVICE entry, then click OK. Select the
"Modify" option, then click "Apply".
|
| Post Reply
|
|
|
|
|
|
|
|
|
|