Al Marino
4/21/2004 6:26:00 PM
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
"Kevin Spencer" <kspencer@takempis.com> wrote in message
news:OIVP2K8JEHA.556@tk2msftngp13.phx.gbl...
> 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" <intelliform@NOTab12THISverizon.net> wrote in message
> news:OUM4E57JEHA.3276@TK2MSFTNGP12.phx.gbl...
> > 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 ?
> >
> >
>
>