Hello everybody,

First of all please forgive me for any kind of ignorance as i'm still in learning stage.

I copied a .mdb file from an installation (os: XP professional) to another installation where also the os is

windows xp professional using a cd. When I installed the file property shows 'read-only'. I unchecked

'read-only' mode. I can add record to any table of the database through MSAccess tool but I can not add

record to any table using ASP forms. The error I get is as follows:

Error Type:
Microsoft JET Database Engine (0x80040E09)
Cannot update. Database or object is read-only.
/asp-learning/Addrecord.asp, line 22
Now I came to know from this forum(url is: http://p2p.wrox.com/topic.asp?TOPIC_ID=9598) that following step

is the solution :

"This usually indicates a permissions problem. The account your web server is running under does not have the

proper permissions to change the database and the folder it resides in. To fix this, give the

IUSR_MachineName permissions to change the database and the folder it resides in."-Imar

Now my question is : What is the detailed steps to give the particular user that type of permissions?

Can I get any help from any body?

Thanks.

Right click the folder and go to properties. You should see a 'Security' tab. If you don't try this:

Open 'My Computer'. Click 'Tools' and then 'Folder Options'. Then click on the 'View' Tab and scroll all the way to the bottom. Uncheck 'Use Simple File Sharing(Recommended)' and click 'Ok' or 'Yes' to the warning.

Once that has been done you should be able to go the the folder where your db.mdb is at and right click on the folder and give <machine name>\aspnet account write access to the folder.

You must be using NTFS and NOT FAT16 or FAT32.

I had the exact same problem. No idea what was wrong as I added all the necesary rights where I could, but no luck. I just moved the file to a partition with FAT32 installed and VOILA!!!!

I wouldn't consider that an improvement. Instead of "setting security" you have now completely removed security. FAT32 disks don't support the NTFS / NT security model, so right now, everyone can read, change or delete stuff in your database. Not a comforting thought.

To successfully set the required permissions, first find out what account IIS uses with this FAQ: http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=287

Once you know the account, follow the steps from this FAQ to set the required permissions: http://Imar.Spaanjaars.Com/QuickDocID.aspx?QUICKDOC=290

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.