im using windows XP Pro with
IIS to run some
ASP scripts on my local machine
however
if i use the following code:
- Code: Select all
SQL = "UPDATE competitors SET wins=" & (wins1 + 1) & " WHERE competitor='" & competitor1 & "'"
all of which is valid and produces the right string when i write it to the screen etc, it says:
- Code: Select all
Technical Information (for support personnel)
* Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/chess/addgame4.asp, line 66
* Browser Type:
Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.7.6) Gecko/20050321 Firefox/1.0.2
anyone know why? previously i had to set read and write permissions for the database, but now i cant find the same place i did that - right clicking on the database and properties doesnt bring up the box it used to!