Read only error

G

Graham Taylor

I have an Access 2003 database which is in the "fpdb" folder of my
webserver. Its located there so that I can use asp to build a web-based
front-end for users to read the database -
http://www.nist.ac.th/maths/test1.asp

The MBD file is edited using Access (2003) and opening it through the UNC
path to the server. We are having problems editing it, getting this error
message:
"The database 'NAME' is read-only.
You won't be able to save changes made to data or object definitions in the
database."

If I make a copy of the file the problem goes away. If I try to delete or
rename the file, I get the message that I cannot, because "It is being used
by another person or program". However, if I check in 'Computer Management'
on the webserver the file is NOT open. If I restart the server the problem
goes away for a few hours (is it a "session" problem?).

When I do open the file for editing, the OPEN MODE in Computer Management
shows the MDB file as "read" and the LDB file shows as "write+read".

Any ideas why this is happening?

Thanks,
Graham
 
D

Douglas J Steele

It's not clear to me from your post whether you're getting the errors
through your ASP page or from users trying to use the database through
Access.

In either case, users require Change permission (Read, Write, eXecute,
Delete) on the folder where the MDB file resides. In the case of ASP, the
security context that requires this permission is usually IUSR_<machine
name>.
 
G

Graham Taylor

Getting the error when trying to open the file in Access to edit it.

Its not as simple as just permissions. As I said, if I reboot the webserver
then the file is fine, for a couple of hours maybe, and then after that it
says its read only when you try to open it in Access. All permissions have
been checked and are correct.

Graham
 
D

Douglas J Steele

I still think it could be permissions, specifically on the IUSR_<machine
name> account.

If that account doesn't have the appropriate permissions, I believe it can
cause problems for other users when it's accessing the database, but not
when it's not.
 
Top