You are Here: FAQ ->Applications->WebFiles->Article #13


How to change permissions for .asp files connecting to an access mdb file


There are two sets of errors you can have for permissions based on asp files accessing mdb files within the db directory.

"Operation must use an updateable query" & "Could not use ''; file already in use."

If you see the following errors "Operation must use an updateable query" or "Could not use ''; file already in use." then change the permissions as follows.

Launch Webfiles from the 1&1 Control Panel, select the db folder and right click on the files on the right.



The error regarding updateable query is based on the permissions of the actual mdb file:

Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/checkout2c.asp, line 317

The permissions that have to be set on the actual file are as follows for user iusr on the file are shown below:



The error based on the actual folder db not having the correct permissions is shown here and the webfiles for iusr:

Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
/checkout2c.asp, line 314

The permissions that have to be set on the actual file are as follows for user iusr on the file are shown below:



SA1B2309


Print Article
How useful was this article?
(From 5 = Very Useful to 1 = Not useful at all):
1 2 3 4 5


 © 2008 1&1 Internet Inc - About 1&1 Internet