|
Subject:
|
Operation must use an updateable query
|
|
Posted By:
|
hchlebowski
|
Post Date:
|
1/19/2006 9:56:08 PM
|
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
|
|
Reply By:
|
joaan
|
Reply Date:
|
1/24/2006 6:11:17 AM
|
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
|
|
