Why is my ASP page returning ...must be updateable query.....

Expand / Collapse
 
     

Why is my ASP page returning ...must be updateable query.. messages when trying to make changes to MS Access DB?


This happens when your .MDB file does not have WRITE permissions.  To fix the problem, go to your Hosting Control Panel, go to Security, go to File Permission on the left hand menu.  In there, browse to the folder that contains your .mdb file and give the .mdb file Read + Write to user IUSR_MEMBERID for the .MDB file.

If this still give you error, you'll have to give write permission to the ENTIRE folder that contains the database .MDB file.





Add Your Comments


Name: *
Email Address:
Web Address:
Verification Code:
*
 

Details
Last Modified:12/24/2008 7:09 PM
Last Modified By: Mark
Type: Error Message
Article not rated yet.
Article has been viewed 626 times.
Options