cant edit access mdb files, keep getting asp error

Question

hallo all. downloaded a forum from a web server to my computer so i can work on it.

anyway the mdb files are locked or something like that and i keep getting this error:

Error Type: Microsoft JET Database Engine (0x80040E09) Cannot update. Database or object is read-only. /forum/login_user.asp, line 168

the files are not read-only. i checked that. what else can it be?...

thanks

Answer 1

The internet user guest account must have modify rights on the .mdb file.

Go to the place on the server where the .mdb file is stored.

Right click the .mdb file

Click security tab

If the iusr account is there, add the Modify rights (Write will be checked too).

If the iuser account is not there, click 'Add..' , enter 'iUSR' in the object names field and press 'Check names', the full qualified iusr account will be shown, click this underlined name and click 'Ok' , check the Modify, Read & Execute, Read and Write rights and press ok.

You might consider doing this on the folder of where the .mdb file is stored (please store the .mdb files in a seperate folder so that the modify rights only apply to the database files, and no other files on your server).