By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,480 Members | 767 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,480 IT Pros & Developers. It's quick & easy.

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

P: n/a
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 #1
Share this Question
Share on Google+
606 Replies


P: n/a
Hi Neil,

Check out ASPNET account permission to access the folder
that Access database is in. The ASPNET account might only
have permission of Read, but not permission of Write.

Hope it helps.

Elton Wang
el********@hotmail.com
-----Original Message-----
Hello,

I am trying to update an MS access database from ASP.NET. I am using IIS onWindows XP Pro. I can issue SELECT statements from ASP.NET using ADO.NET butI cannot seem to be able to carry out INSERT statements. Here is the errorwhich 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 thatthey were able to resolve it by setting NTFS file permissions. However I amnot sure about how to go about doing this:

I wonder whether someone could please post precise instructions on how tosolve this. I have tried running inetmgr and setting them from there butI must have done something wrong as I am still getting the same error.
Thanks a lot!!!

Neil
.

Nov 19 '05 #2

P: n/a
Thank you for your reply,

What I ended up doing was I clicked on the MS Access (.mdb) file and
then under Properties -> Securities added an account called Everyone
and set permissions to "Full Control" for this account. So now I can
update the MS Access file via the ASP.NET web interface.

Regards,

Neil

Nov 19 '05 #3

P: n/a
Hi Neil,

This refers to ASP, but the fix is the same if you substitute the ASPNET
account for IUSR_<machinename>

PRB: ASP Returns 'Operation Must Use an Updateable Query' Error

http://support.microsoft.com/default...b;en-us;175168

"Neil Zanella" <nz******@cs.mun.ca> wrote in message
news:b6**************************@posting.google.c om...
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 #4

P: n/a
<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 #5

P: n/a
<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 #6

P: n/a
<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 #7

P: n/a
<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 #8

P: n/a
<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 #9

P: n/a
<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 #10

P: n/a
<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 #11

P: n/a
<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 #12

P: n/a
<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 #13

P: n/a
<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 #14

P: n/a
<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 #15

P: n/a
<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 #16

P: n/a
<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 #17

P: n/a
<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 #18

P: n/a
<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 #19

P: n/a
<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 #20

P: n/a
<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 #21

P: n/a
<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 #22

P: n/a
<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 #23

P: n/a
<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 #24

P: n/a
<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 #25

P: n/a
<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 #26

P: n/a
<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 #27

P: n/a
<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 #28

P: n/a
<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 #29

P: n/a
<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 #30

P: n/a
<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 #31

P: n/a
<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 #32

P: n/a
<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 #33

P: n/a
<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 #34

P: n/a
<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 #35

P: n/a
<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 #36

P: n/a
<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 #37

P: n/a
<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 #38

P: n/a
<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 #39

P: n/a
<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 #40

P: n/a
<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 #41

P: n/a
<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 #42

P: n/a
<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 #43

P: n/a
<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 #44

P: n/a
<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 #45

P: n/a
<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 #46

P: n/a
<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 #47

P: n/a
<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 #48

P: n/a
<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 #49

P: n/a
<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 #50

606 Replies

This discussion thread is closed

Replies have been disabled for this discussion.