Problem with IIS webserver
I built a page to interact with an access database. When I run the page with the web server built into VWD express. I have no problems and I can add/update/view data from database with no problems. When I add all the files from the folder with that web page to the folder my xp pro IIS webserver uses. The page displays normally. But when I attempt to add anything to the database, I get the following error:
Operation must use an updateable query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Operation must use an updateable query.
Line 99: conAdd.Open()
Line 100: cmdAdd.ExecuteNonQuery()
Line 101: conAdd.Close()
If anyone knows why this error is comming, I would like some feedback. Thank You.