Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
 Posted - 2006-09-22 : 00:18:20
|
| I am trying to update an MS access database from ASP.NET. I am using IIS on Windows XP Pro. I want insert from ASP.NET using ADO.NET but I cannot seem to be able to carry out INSERT statements. Here is the errorwhich I am getting:Operation must use an updateable query.Exception Details: System.Data.OleDb.OleDbException:Line 67: cmd.ExecuteNonQuery();Ranjeet Kumar Singh |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-22 : 00:21:21
|
| Probably best you supply the INSERT statement that's causing the problem...... |
 |
|
|
ranjeetsingh_6
Posting Yak Master
125 Posts |
Posted - 2006-09-22 : 00:32:41
|
| Insert statment is write i have check .does read/write permision setting nessary on MS access to use ASP.netIf it necessary then how setting doneRanjeet Kumar Singh |
|
|
|
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2006-10-05 : 07:15:25
|
| Do you want to insert data into not table but query? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2006-10-05 : 08:42:52
|
| You must have read/write permissions to the access-file to be able to do inserts/updates/deletes. Go to IIS management, locate the access-file, right-click it and make sure that both read and write are checked.--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
|
|
|
|
|
|
problem Operation must use an updateable query