Solved

Operation must use an updateable query. MDB file is on a different server

Posted on 2004-10-04
7
261 Views
Last Modified: 2012-05-05
hello there!
im sure this question must've been asked several times but i couldnt find an specific answer for my specific question.
anyway here it is...

i have a simple asp.net apps that connects to an mdb file. i put them in the server (under wwwroot).
at first i encountered this updateable problem but adding iusr_machine with read/write access did the trick.
now here's the problem, i have to put my mdb to a different server (for some reasons). what i did is change the path in web.config and the apps can read the mdb until i have to make some changes and i got the "must use an updateable query" problem. i tried the solution by adding the iusr_machine (this time on the other server) with the read/write acess but still it didnt solve the problem.

can somebody help me with this?
is it possible to put the mdb on a different server while the code is in a diff server?
thanks in advance for the help!
0
Comment
Question by:c0zee
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 17

Expert Comment

by:AerosSaga
ID: 12222220
This is a permissions issue, make sure the ASP.NET Worker account has write privaledges to the .mdb

Aeros
0
 
LVL 17

Expert Comment

by:AerosSaga
ID: 12222228
By default its NT Athority/Network Services for a 2003 server & MACHINE/ASP.NET for a 2000 server.

0
 
LVL 17

Accepted Solution

by:
AerosSaga earned 125 total points
ID: 12222235
right click on the folder of the .mdb or the .mdb hit properties

Click Security

Add the Neccessary account and grant neccesary privledges
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 17

Expert Comment

by:AerosSaga
ID: 12222242
Give the local account the application is running under write permissions on the remote computer
0
 

Author Comment

by:c0zee
ID: 12222292
the machine that has the code resides on a win2003 server. there is an ASPNET user there and i added it.
the machine that holds the mdb now is in a win2k server. i dont see any ASPNET user.
0
 

Author Comment

by:c0zee
ID: 12222353
i already added the user IUSR_machine (the one that holds the mdb) a read/write access to the directory that contains the database and i still get the error.

anybody?
0
 

Author Comment

by:c0zee
ID: 12222785
thanks for all the help guys!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I have developed many web applications with asp & asp.net and to add and use a dropdownlist was always a very simple task, but with the new asp.net, setting the value is a bit tricky and its not similar to the old traditional method. So in this a…
One of the pain points with developing AJAX, JavaScript, JQuery, and other client-side behaviors is that JavaScript doesn’t allow for cross domain request for pulling content. For example, JavaScript code on www.johnchapman.name could not pull conte…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question