Link to home
Start Free TrialLog in
Avatar of c0zee
c0zee

asked on

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

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!
Avatar of AerosSaga
AerosSaga

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

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

ASKER CERTIFIED SOLUTION
Avatar of AerosSaga
AerosSaga

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Give the local account the application is running under write permissions on the remote computer
Avatar of c0zee

ASKER

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.
Avatar of c0zee

ASKER

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?
Avatar of c0zee

ASKER

thanks for all the help guys!