Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2004-10-04
7
Medium Priority
?
265 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 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
0
Independent Software Vendors: 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

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…
Sometimes in DotNetNuke module development you want to swap controls within the same module definition.  In doing this DNN (somewhat annoyingly) swaps the Skin and Container definitions to the default admin selections.  To get around this you need t…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

598 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