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

Posted on 2004-10-04
Medium Priority
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!
Question by:c0zee
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
LVL 17

Expert Comment

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

LVL 17

Expert Comment

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

LVL 17

Accepted Solution

AerosSaga earned 500 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

LVL 17

Expert Comment

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

Author Comment

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.

Author Comment

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.


Author Comment

ID: 12222785
thanks for all the help guys!

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

I recently went through the process of creating a Calendar Control of events with the basis of using a database to keep track of the dates that are selectable, one requirement was to have the selected date pop-up in a simple lightbox.  At first this…
Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

770 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