On my ASP page i have coded a insert query, the query is correct however when i check on the browser i get this error
HTTP 500.100 - Internal Server Error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/diary/entertodiary.asp, line 17
I am not sure what is wrong, could it be the database settings? or the ODBC settings? i have sucessfully been able to use a select query, but it does not like the insert query. The query isnt even updating! its inserting, this is the code:
insertDiary = "insert into activity values (22,'abna')"
Help!
Thanks
HTTP 500.100 - Internal Server Error
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/diary/entertodiary.asp, line 17
I am not sure what is wrong, could it be the database settings? or the ODBC settings? i have sucessfully been able to use a select query, but it does not like the insert query. The query isnt even updating! its inserting, this is the code:
insertDiary = "insert into activity values (22,'abna')"
Help!
Thanks