ToDO application
-
I am trying to get the ToDo application downloaded from this site running on my machine. In the installation procedure, Step five states: You must give the local machine ASPNET account Modify, Read & Execute, Read and Write permissions to the file todo.mdb, or you will get the somewhat confusing error message "Operation must use an updateable query" when trying to update entries. Welcome to the world of secure programming! Would anyone be able to shed some light on how exactly this is done? Cheers Rory
-
I am trying to get the ToDo application downloaded from this site running on my machine. In the installation procedure, Step five states: You must give the local machine ASPNET account Modify, Read & Execute, Read and Write permissions to the file todo.mdb, or you will get the somewhat confusing error message "Operation must use an updateable query" when trying to update entries. Welcome to the world of secure programming! Would anyone be able to shed some light on how exactly this is done? Cheers Rory
Hope this helps... This project contains a Microsoft Access database (C:\Inetpub\wwwroot\ToDo\ToDo.mdb). You must give the local machine ASPNET account Modify, Read & Execute, Read and Write permissions to the file todo.mdb, or you will get the somewhat confusing error message "Operation must use an updateable query" when trying to update entries. Welcome to the world of secure programming! To change file permissions use the following instructions Open Windows Explorer and depending on your operating system perform one of the following: For Windows 2000: Right-click on the folder and select Sharing and Security, select the Security tab, click Add, in Enter the object names to select enter “ASPNET”, click OK. On the Security tab the ASP.NET Machine Account (\ASPNET) is selected, in Permissions check the Allow checkbox for the Write permission, click OK. For Windows 2003: Do the same as for Windows 2000 but then select the Network Services instead of the ASPNET account. This has to do with the diffrent ways ASP.NET runs on Windows 2000 and Windows 2003. For XP Professional: XP hides true folder permissions control by default. After you turn off this feature, you can then give 'write' permission to All Users for the .mdb. a. Open the Explorer - click on Tools and then Folder Options - goto View tab - scroll down all the way and the last item will say "Use simple file sharing" - uncheck it if it is checked. b. Right click on the folder and click "Sharing and Security". Click on the Security tab - select Everyone from User - check "Write" checkbox under Everyone as a user VOILA.
-
Hope this helps... This project contains a Microsoft Access database (C:\Inetpub\wwwroot\ToDo\ToDo.mdb). You must give the local machine ASPNET account Modify, Read & Execute, Read and Write permissions to the file todo.mdb, or you will get the somewhat confusing error message "Operation must use an updateable query" when trying to update entries. Welcome to the world of secure programming! To change file permissions use the following instructions Open Windows Explorer and depending on your operating system perform one of the following: For Windows 2000: Right-click on the folder and select Sharing and Security, select the Security tab, click Add, in Enter the object names to select enter “ASPNET”, click OK. On the Security tab the ASP.NET Machine Account (\ASPNET) is selected, in Permissions check the Allow checkbox for the Write permission, click OK. For Windows 2003: Do the same as for Windows 2000 but then select the Network Services instead of the ASPNET account. This has to do with the diffrent ways ASP.NET runs on Windows 2000 and Windows 2003. For XP Professional: XP hides true folder permissions control by default. After you turn off this feature, you can then give 'write' permission to All Users for the .mdb. a. Open the Explorer - click on Tools and then Folder Options - goto View tab - scroll down all the way and the last item will say "Use simple file sharing" - uncheck it if it is checked. b. Right click on the folder and click "Sharing and Security". Click on the Security tab - select Everyone from User - check "Write" checkbox under Everyone as a user VOILA.
Thanks mark That worked a treat and saved me alot of stress and time, cheers again