Great to hear tat.

Happy programming
life's Ng

rg77: have an idea ?!!

i have the same problem.but i got nothing from doing that sharing.i noticed that another file is created with .ldb extension but the same name of data base file i use .it looks like locked file .do you think this is the problem ? ..

i am confused many times ..

Here are the specs and the steps.
WinXP Pro SP2, Net Framework 1.1

The Access File fails with updates.
1. Added <identity impersonate="true" /> to the <system.web> node in web.config.
2. Disabled Simple File Sharing through the tools menu in Explorer
2a. Added the ASPNET Account with 'Full Control' to the folder where the Access file is stored.

Still did not work.
3. When back to the security tab ( visible after disabling 'simple file sharing' from the View Tab (Folder Options node selected from the tools menu in Explorer ))
3a. Click 'Share this folder' and added 'Full Control Permissions' (undesireable solution, which did not work anyway).

What else can I do? Is there something that needs to be done through IIS?

There are only two tables. I tried deleting the relationship to see if I could manage to update a record without enforcing referential integrity and still had no luck.

I am feeling at wit's end. The end of my rope. The end. The end!

Arrrrrgh! - Charlie Brown

Relax bro,

SP2... tats the source of ur problem if i not wrong... i dont know much bout tat, but u most likely have to deal with the firewall/iis in ur com. there is some threads i read b4 bout SP2 with .net..

or may b u should try to re-register ur Asp.net with IIS
http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=740907

Hope this help
life's Ng

I am having this problem for days now. I updated the NTFS permissions for the Network Service account, the IUSR-account and the IIS_WPG account so that they all have write access to my access database. The strange thing is that right after I have rebooted my server and try to open the access database I can write or change whatever I want in the database directly. Once I have ran my web application which is making a connection to this db and I try to open it directly on the server with MS Access I get the message that it is read-only. Is there somewhere a connection made via my webpage that is not closing properly?

Thanks in advance for any advice

I updated the NTFS permissions for the Network Service account, the IUSR-account and the IIS_WPG account so that they all have write access to my access database.

Permissions need to be for the folder where mdb file resides, not just for the mdb file itself. (Creating the ldb, locking file needs those permissions). Did you check that?

Yes I checked that. The ldb file is actually created.

Thanks, I set the sharing permissions on the folder containing my database to:

Share this folder on the network and
Allow Network Users to change my files

This fixed the problem on my system. (XP Pro, Access 2003, .NET 1.1)

I also tried adding the line <identity impersonate="true" /> to my web.config file but that produced an unspecified error.

I still don't understand why I need to set sharing permissions when I am the only user of my computer and I'm not on a network but at least its working.

Hi guys,
   I need help! i'm new to this, pls explain it in basic terms to me.

"Operation must use an updateable query error when using Access db" is the problem. I've read some posts, and tried the permissions, I've permitted Script Source Access, Read, Write, Directory Browsing, Log visits, and Index this resources in Properties of the webfolder in WWWRoot, since I wasn't sure which to check. After i applied the changes, a box titled "Inheritance Overrides" poped up, and it mentioned something about Permissions Access. so i just selected all. and applied changes. I still get the same problems when trying to delete or update items using the browser in VS.net.

Hi, I don't know what the other guys have said but I used to have this problem.

My discovery (right or wrong) a year or two ago was that the IIS user account was part of the Windows "Users" group.  I decided to give the Users group full rights to the database as well and I've never had another problem since.

Regards

David

That permission setup should apply to the folder where the mdb file resides. So if it is in subfolder of wwwroot, setting permissions of wwwroot doesn't help, you need to set permissions to the subfolder.

Thanks, David... adding the Users group to that folder and giving them Full Control worked for me as well!  I could not get any of the other suggestions to work.  My only guess is that a MS security patch changed how the permissions work.

Bachino wrote:

My discovery (right or wrong) a year or two ago was that the IIS user account was part of the Windows "Users" group.  I decided to give the Users group full rights to the database as well and I've never had another problem since.

I have windows XP Professional, i tried everything specified here and in other related threads but it still didn't work for me. It was very frustrating.  What eventually worked was removing the Deny permissions on IUSER_Computer name and IWAM_computer name acounts. Even if you give both of these accounts Full Control under the Allow column, if any permissions are set under the Deny column (the default is deny Write access on both of these accounts) the Deny permissions take precedence.

I went back and reset all the File Sharing and other wild-goose permission changes back to normal/default and it still works, so this must have been the main cause of problem.

 

    

this helps me alot. thanks...

Bachino:

My discovery (right or wrong) a year or two ago was that the IIS user account was part of the Windows "Users" group.  I decided to give the Users group full rights to the database as well and I've never had another problem since.

This worked for me as well, after I had already tried the other suggestions. Much thanks!