Hi Kaustav,
You're right that NTFS security is blocking write access to your .MDB. However, the fix is easy.
1. Navigate to the folder where your database resides in using the Windows Explorer (for example: c:\Inetpub\wwwroot\Database).
2. Right-click the folder (and not the .mdb file) and choose Properties.
3. Swith to the Security tab.
4. Click Add and select the user IUSR_MachineName where MachineName is the name of your server.
5. Make sure this account has sufficient rights; Full Control would work, but Modify rights is preferred, as it gives just the necessary permissions.
6. If your site is running in its own process space (configurable through the IIS MMC), you may need to add the IWAM_MachineName account as well.
From now on, IIS should be able to access the database and modify it.
Note: If you don't have a Security tab on the Properties dialog, do this:
1. Open Windows Explorer
2. Choose Tools | Folder Options...
3. Open the View tab.
4. Scroll down and deselect Use simple file sharing (recommended).
Although it's recommended by Microsoft for "normal use", this feature blocks your ability to set permissions yourself, so you need to disable it.
HtH,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|
