ASP Databse Write/Modify Permissions

Question: I have an ASP application which tries to write or modify the database, it works in my PC but does not work in your server. I recieve this error :

Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

Answer: You need to give Internet User write permission to .mdb file. In your computer and by default everyone has full control on the files, but in the server and because of security, access is limited to read for internet user.

In order to fix the problem, go to advanced section of control panel,click on Folder Control, browse and find the file you want and give it the write permission. However we strongly advise you to use "private" folder and DNS less connections, this folder is outside your web root and has write internet permission by default.



Return To Knowledge Base Search Page