8
Professional C# PCSWebApp3 Application
lDebugging Access to the Access Database when setting up the application
l
• The web app to be described next, from the WROX Professional C# book, may give the error message
l “Operation must use an updateable query”
l when
l int queryResult = insertCommand.ExecuteNonQuery();
l Is executed.  This is because the web app does not have write access to the Access database, pcswebapp3.mdb, in the web directory.
l
l Bring up Explorer on that directory, right click on this .mdb file in Explorer, pick properties, security tab, and for each of the accounts in the list
l Web anonymous users
l Web applications
l ), click the Read and Write access permissions boxes.  (This is for Windows 2000 Server; for XP, give Everyone write access.)  Click OK.  Then the app will work.