IIS configuration for writing to database

anyone know why I get the following error when trying to write to an Access database using ASP. My computer is WinXp running IIS5.0.
IIS is set up with read/write everything. I was told that my computer (server) also needed write access?? Make sense?

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

/wwwroot/KLP Curriculum Site/resource_addtodatabase.asp, line
35

You need to set the read/write option for the database.

You do it here:
Control Panel -> Administrative tools -> Internet Information Services -> Browse to you find you database -> Rightclick and choose All tasks -> Guidelines for "something"

yeah, Im sure I did that...tried everything that I am familiar with. Its late now, my brain is melting Will try on the morrow.

Thanks for rollover info on other thread also.

Permissions are not handled through IIS. They are handled by the OS. So, open up windows explorer, find the DB file, right click, ensure that the file's attributes are not set to read only. Then click the Security tab. Assign the IUSR_YourMachineName user full permissions.

IUSR_YourMachineName is the username which IIS operates as. Keep this in mind for any future problems, as you'll often need to setup it's permission on folders/files, esp. if you do any file uploading projects.

I was aware that the OS needed write permissions but wasnt sure how to do this. So, its in Security from properties of file. Thanks...I will test this tonight.

Yup. Also, you can apply your secuity settings to entire folders using the same method.

OK. what am I doing wrong here, properties of database (right click) only give me General & Summary options, no Security option. Its not read only aswell. I tested this on Win2000 Pro and it was ok but this computer is XP Pro and I dont get the option...

To turn Simple File Sharing on or off in Windows XP Professional:
Double-click My Computer on the desktop.
On the Tools menu, click Folder Options.
Click the View tab, and then click to select the Use Simple File Sharing (Recommended) check box to enable Simple File Sharing (click to clear this check box to disable this feature).

http://support.microsoft.com/?kbid=304040

Thanks for the info. OK I have tried everything now. All permissions set correctly, File Sharing is on etc etc. Still no joy with writing to database with IIS5 and WinXP Pro. No problems with the coding as it works fine on NT server and IIS Win2000.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

/KLP Curriculum Site/resources/resourcesadd.asp, line 104




help

Make sure the file is not set to read-only.

So you've setup IUSR_machinename with full access?

If so, and you're still getting the error - insert the error message into google. That's how i solve most issues.

I am looking for the technology as one computer can control all other computers.If anyone replies, appreciated.