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

Posted on 2004-10-04
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 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
  • 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 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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Lots of people ask this question on how to extend the “MembershipProvider” to make use of custom authentication like using existing database or make use of some other way of authentication. Many blogs show you how to extend the membership provider c…
User art_snob ( encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now