Setting Permissions to Access Database - step by step guide

[Shadow Wizard]

The following will solve those two common errors:
---
Operation must use an updateable query
cannot update database database is readonly
---
Such errors occur when you try to update/delete/insert records
to Access Database, but don't have proper permissions.
Note, this is not IIS problem but rather Windows problem.
Follow those steps, according to the Server OS:
Window 2000 Professional/Windows 2000 Server

1. Browse to the database file meaning the .MDB file by double
   clicking My Computer and browsing to the file.
2. Right click the file.
3. Choose Properties
4. Go to the Security Tab
5. Click the Add button
   
6. Select IUSR_[computer name] and click Add
   
7. Click OK
   
8. Check the checkbox for Write permission in the Allow column
   
9. Confirm.

Window XP/Windows 2003 Server

1. Browse to the database file meaning the .MDB file by double
   clicking My Computer and browsing to the file.
2. Windows XP users:
   
   1. Go to Tools --> Folder Options
      
   2. Go to View tab
   3. Uncheck "Use simple file sharing" and confirm.
      
3. Right click the file.
4. Choose Properties
5. Go to the Security Tab (XP users - if it won't show make sure
   you followed instructions in step #2)
6. Click the Add button
7. Type IUSR_[machine name] in the box, replace "machine name"
   with the name of the computer as you can see in the
   "From this location" textbox
   
8. Click OK, check the checkbox for Write permission in Allow column.
   
9. Confirm.

That's all, you may have to repeat above steps to the folder
containing the mdb file as well.

[Compstudent]

Ur a star....i really needed this... Thanks

[Poongody]

Thanks a mille.

[lostside]

It solved my problem too.

will the Uncheck "Use simple file sharing" change anything else in the way share files?

[Shadow Wizard]

It solved my problem too.

will the Uncheck "Use simple file sharing" change anything else in the way share files?

as far as I know, it won't change anything else - only add the Security tab
to the Properties window.

[Phoenix_riser]

Just set up new XP Pro - added IIS but no security tab! How do I add this.

Thank you in advance

[Shadow Wizard]

Just set up new XP Pro - added IIS but no security tab! How do I add this.

Thank you in advance

the Security tab has nothing to do with IIS..
read the section "Window XP/Windows 2003 Server" and see step #2.
it explain what you have to change in the Folder Options.

[codeidea]

we wish IIS can set folder write/read rights for every user, it is easy for us,I have meet this problem for serval times too.

[remi]

Thanks for sharing the useful information.
This will help many new bees like me...

Web Design Company | Delete history

[navkeshchawla]

That s what I did, I could not even locate security Tab. May b I am very backward. Please help

[Shadow Wizard]

in XP, this tab won't appear by default.
refer to step #2:

Go to Tools --> Folder Options
Go to View tab
Uncheck "Use simple file sharing" and confirm.

[xxJanexx]

I can`t see the option from View:

http://xs513.xs.to/xs513/07104/cantseeit.PNG

[Shadow Wizard]

I think it's available only for XP professional edition.
what OS you have?

[xxJanexx]

Home.

[Shadow Wizard]

Home.

so you can't install IIS and can't use ASP.. this guide is not relevant for you.