Error:
-
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. /tablename_edit.asp, line xxx
Solution:
Scenario1: Testing on the Web Server
If you are testing the program at web-server, your web hosting provider should have a designated folder for databases where correct permissions are already set. You need to move database file to that directory and update connection string accordingly.
Example:
Let's say you have the following directory structure on you web server:
cgi-bin
database
logs
www/asp/db
Where:
database - designated database
folder
www/asp - folder where ASP files
reside
www/asp/db - folder where database file
resides
Old connection string should look like this:
strConnection = "Provider=MSDataShape;DBQ=" & server.mappath("db\db1.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"
New connection string in this example will be:
strConnection = "Provider=MSDataShape;DBQ=" & server.mappath("..\..\database\db1.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"
Possible problem:
Some Web servers do not allow parent paths.
Solution:
If parent paths are not allowed you can specify full physical path to database instead. To find where exactly database file resides put the following test.asp file to the root directory and run it in browser.
test.asp:
<% response.write Server.MapPath("test.asp") %>
It should print something like this:
W:\Webspace\resadmin\xlinesoft.com\www\test.asp
Now open include/dbconnection.asp file in text editor. It should look like this:
strConnection = "DBQ=" & server.mappath("..\database\db1.mdb") & ";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"
Here is how you need to modify it:
strConnection = "DBQ=W:\Webspace\resadmin\xlinesoft.com\database\db1.mdb";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"
Scenario2: Testing Locally
If you are testing locally and received the above described error, that usually means that there is a permission problem. To fix that, you need to give full permission to EVERYONE to the directory where database is located. To do that ,you need to:
-
Right-click on the folder where the database is located
-
Go to Properties
-
Go to Security
-
Add user named EVERYONE (if don't exists)
-
Assign Full Permissions for user EVERYONE
-
Click OK
For Windows XP users only:
If permission tab is not enabled or missing or sharing tab does not allow to grant the permission, you need to do the following:
-
Go to the folder where the database is located
-
Go to Tools->Folder Options->View and uncheck Use simple file sharing (recommended) (last option in the list)
-
Click OK
-
Now you can right-click on the folder where the database is located
-
Go to Properties
-
Go to Security
-
Add user named EVERYONE (if don't exists)
-
Assign Full Permissions for user EVERYONE
-
Click OK