err80004005 Operation must use an updateable query
icaro | Posted 5:49pm 20. May 2001 Server Time |
Can someone tell me what this error is all about.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/inclusao.asp, line 47
I send the database using cuteftp...
This post have been closed for new replies
Biosphere | Posted 6:27pm 20. May 2001 Server Time ||
Check your attributes of the file accessing the database, it has to have permission for it to access it. READ & EXECUTE are a must and I'm not sure but I think WRITE has to be as well, this solved it on my machine :o)
Someone correct me about the WRITE if I'm wrong :o)
sveverica | Posted 10:07am 21. May 2001 Server Time |
I'm having trouble, too. This .asp stuff is new to me and everywhere I study it, I can't find any reference to the permissions. Where do you assign the permissions? Do .ASPs have to be registered on the server? Can anyone help?
Bcooper | Posted 8:54am 22. May 2001 Server Time |
It's referring to file security on the PC itself.
Go into Windows Explorer and right-click on the folder or file in question. Select "Properties". You should find a "Security" tab. It is there that you assign permissions.
Generally, when dealing with databases and such, you'll be needing to assign (at least) Read permission to a user named IUSR_(network name of your computer). If you want Internet Users to be able to write to the database, they need write permission and, if you're using Access, Write/Create permission to the folder as well (to generate the .ldb file).
IT Support Technician
jychang | Posted 9:47am 5. April 2002 Server Time |
I have same problem (error 80004005, Operation must use an updateable query)
And I checked the database. It has permission for READ &EXECUTE.
But still have same error message.
One more thing I need to tell you..
We move this asp.program to window2000sever newly. We just simply copy the program to new server. Since then, I have this error. The program in Old server(NT) still working fine.
eric1973 | Posted 10:28am 5. April 2002 Server Time |
right click on the file in the file explorer and click the security tab then set modify rights for IUSR\MachineName
jychang | Posted 12:12am 5. April 2002 Server Time |
Thank you so much!
Show all replies to 'err80004005 Operation must use an updateable query'