newbie ado

[Al Marino]

Hi All

simple code on an Access db "test", fields InUse, ExpDate

<%
Dim oConn, dtmDate, strUpdate

set oConn = server.createobject("adodb.connection")
oConn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\inetpub\wwwroot\nwbl\test.mdb;"

dtmDate = Date()-30
strUpdate = "Update TEST Set InUst = 'No' where ExpDate < # " & dtmDelDate
&"#"

oConn.execute strUpdate
%>

when I run this I get an error

"Operation must use an updateable query"

can anyone help ?

 

[Kevin Spencer]

Make sure that the folder containing your .mdb file has "Modify" (file)
permission granted to the IUSER_<machine name> user account on the server.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

 

[Al Marino]

running XP, IIS, FrontPage, all on one machine local

using IIS, i have verified the IUSR_<machine name> has read/write
on directory and file (i assume you had typo of IUSER)

any other ideas ?

al