473,322 Members | 1,734 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

SQL updates on MS Access Database: error: Operation must use an updateable query.

Hello,

I am trying to update an MS access database from ASP.NET. I am using IIS on
Windows XP Pro. I can issue SELECT statements from ASP.NET using ADO.NET but
I cannot seem to be able to carry out INSERT statements. Here is the error
which I am getting:

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

Line 67: cmd.ExecuteNonQuery();

I have found some posts where users had a similar problem and it seems that
they were able to resolve it by setting NTFS file permissions. However I am
not sure about how to go about doing this:

I wonder whether someone could please post precise instructions on how to
solve this. I have tried running inetmgr and setting them from there but
I must have done something wrong as I am still getting the same error.

Thanks a lot!!!

Neil
Nov 19 '05
606 14120
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #501
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #502
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #503
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #504
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #505
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #506
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #507
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #508
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #509
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #510
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #511
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #512
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #513
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #514
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #515
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #516
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #517
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #518
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #519
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #520
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #521
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #522
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #523
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #524
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #525
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #526
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #527
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #528
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #529
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #530
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #531
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #532
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #533
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #534
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #535
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #536
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #537
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #538
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #539
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #540
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #541
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #542
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #543
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #544
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #545
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #546
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #547
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #548
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #549
<P>Did you get your question answered? What was the correct solution?</P>
<P>Thanks</P>
sent via http://www.visual-basic-data-mining.com
Nov 19 '05 #550

This thread has been closed and replies have been disabled. Please start a new discussion.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.