Hi Guys;

Recently I have to reinstalled my WindowsXP Prof. and now my app. done in VS.NET 2003 won’t update it’s Access 2000 db. I changed the db’s folder property (Web Sharing/Share this folder/Edit Properties/Check – Read & Write) but without effect.

There is another folder’s Read-Only attribute in the General tab but when I switch it off and go back to it, it still is on. Is this the problem? And if it is, why can’t I turn it off?

I copy the db directly to the c: root and redirected the Connection String to it but no budge, everything works but update.

Following some ASP.NET Forums advice I went to Computer Manager/Local Users and Groups/Users, copy the “ASP.NET Machine Account”, went to the db’s folder/properties/Web Sharing, pasted the “ASP.NET Machine Account” in the Aliases list, changed the Edit Properties to Read, Write and Execute (I try it all possible ways; “ASP.NET”, Read, Write, Script), and still no go.

Can you write me line by line how to go about it? (Novice)

Thanks a lot. Henry

Hello,

you need to assign the user IUSR\IUSR_COMPUTERNAME, where COMPUTERNAME is the name of your machine, permission to WRITE. This is not a matter of Web Sharing or a Share, but a Security issue. If your cannot find the Security tab in the properties window of your MS Access file or the folder containing the db, begin with the following:

- On the Tools menu in Windows Explorer, choose Folder Options
- Choose the View tab
- Uncheck "Use simple file sharing"

Click OK and you're good to go!

If you already have the Security tab in the file/folder properties window, all you need to do is choose the Security tab, and click Add. To choose user, click Advanced and then click Search. You'll find a list of local users at the bottom of the window. Find IUSR\IUSR_COMPUTERNAME in the list. Add WRITE to the list of permissions for this user and the problem is solved.


/J Andersson