Solved

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

Posted on 2004-10-04
7
255 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
  • 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This article discusses the ASP.NET AJAX ModalPopupExtender control. In this article we will show how to use the ModalPopupExtender control, how to display/show/call the ASP.NET AJAX ModalPopupExtender control from javascript, how to show/display/cal…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

911 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

20 Experts available now in Live!

Get 1:1 Help Now