Home » Posts tagged "Access" (Page 5)

Archive for the 'Access' Tag

Operation must use an updateable query

Server Error in ‘/TestSite’ Application Operation must use an updateable query. Issue: Denied right to ASP.NET Machine Account to modify access db Resolution – Make sure Internet Guest Account has a read/write rights – Open application folder properties and add ASP.NET Machine Account if does not exist – Permit the ASP.NET Machine Account to modify […]

Calculating total from recordset using “select case”

Here is code in classic asp Here is example on how to calculate recordset total using “select case” statement. I have calculated essay and resume scholarship values based on records fromĀ  two essay and resume tables, and queried results based on applicant-student registration ID or name. Then I calculated “total score” of each student using […]