problems connecting to database

[benbacardi]

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!

[Rob]

http://www.webforumz.com/viewtopic.p...te+permissions

Dude.... pls try and search before posting.... we've covered this many times...

Indeed, it was your own self who posted that thread... lmao!

[benbacardi]

i know but i followed what was mentioned in that post before, and this time - it DID NOT work

[Rob]

for whaever reason dude, the permissions on the database do not allow the script to update the database.

[benbacardi]

yea but i cant find where to change the permissions - i cant right click on it and find it anymore... sorry rob!

[Smokie]

Ben,

Right click on the folder which the database is in... and on the "security" tab make sure the "write" permissions are set.

[benbacardi]

smokie

thanks but when i right click, and click properties, i only get 2 tabs - general and summary - there is nowhere like there was before to enter read/write permissions. if there was, i would know how to do it because i've done it before! thats why this is so frustrating...

[Rob]

try my post here:-
disable simple file sharing

[benbacardi]

thanks rob