Unanswered: Unable to use Query in my ASP application
I have just picked up ASP a month ago and i am learning ASP fast with additional knowledge in C programming, few knowledge in query language and html. However, I receive the same error message whenever I use query language to modify my database , as in using INSERT, UPDATE and DELETE. I attach the add data html and code along with this thread. The database only consist of a table call CDs that has 3 fields of data, which are artist, title and format. Hope someone can give me a hand here. Thanks!
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
How can I access to my database? Is there any extra configuration in the ODBC? I had been successfully read from the database anyway, using the select function. I assumed it's a backward process to modify the database. Have I got the idea wrong?
Would you recommend me to format my PC? I tried install and unsinstalled IIS in my computer a few times already. Also have all the permission configured. I did the same for other computer but I can used the IIS smoothly without any problem.