Problem in updating time field

[Bhavin]

Hi
I'm trying to update time field which MSACCESS using query

Sql2 = "Update tblExtraNetUsers SET Lo_date = " & Date()
& ",Lo_time =#" & FormatDateTime(Time(),4) &"# ,Lo_count
= " & rs("Lo_count") + 1 & " WHERE UserLogOn = 'david'"

But its always gives a error message
Operation must use an updateable query.

Thanx at advance

[Ken Schaefer]

Check your NTFS permissions. You probably need to give the IUSR account
sufficient privileges to update the database.

Cheers
Ken

"Bhavin" <anonymous@discussions.microsoft.com> wrote in message
news:068901c3979e$5c1d8010$a601280a@phx.gbl...
: Hi
: I'm trying to update time field which MSACCESS using query
:
: Sql2 = "Update tblExtraNetUsers SET Lo_date = " & Date()
: & ",Lo_time =#" & FormatDateTime(Time(),4) &"# ,Lo_count
: = " & rs("Lo_count") + 1 & " WHERE UserLogOn = 'david'"
:
: But its always gives a error message
: Operation must use an updateable query.
:
: Thanx at advance

[Bhavin]

How can I check NTFS permission and how to give the IUSR
account sufficient privileges to update the database.
-Bhavin

>-----Original Message-----
>Check your NTFS permissions. You probably need to give

the IUSR account

>sufficient privileges to update the database.
>
>Cheers
>Ken
>
>"Bhavin" <anonymous@discussions.microsoft.com> wrote in

message

>news:068901c3979e$5c1d8010$a601280a@phx.gbl...
>: Hi
>: I'm trying to update time field which MSACCESS using

query

>:
>: Sql2 = "Update tblExtraNetUsers SET Lo_date = " & Date

()

>: & ",Lo_time =#" & FormatDateTime(Time(),4)

&"# ,Lo_count

>: = " & rs("Lo_count") + 1 & " WHERE UserLogOn = 'david'"
>:
>: But its always gives a error message
>: Operation must use an updateable query.
>:
>: Thanx at advance
>
>
>.
>

[Ken Schaefer]

Right-click on a folder in Explorer -> Properties -> Security tab.

IUSR_<machinename> needs Read/Execute/Write
Creator/Owner should have "Full Control"

Cheers
Ken

"Bhavin" <anonymous@discussions.microsoft.com> wrote in message
news:04ba01c3982c$15d3a240$a401280a@phx.gbl...
: How can I check NTFS permission and how to give the IUSR
: account sufficient privileges to update the database.
: -Bhavin
: >-----Original Message-----
: >Check your NTFS permissions. You probably need to give
: the IUSR account
: >sufficient privileges to update the database.
: >
: >Cheers
: >Ken
: >
: >"Bhavin" <anonymous@discussions.microsoft.com> wrote in
: message
: >news:068901c3979e$5c1d8010$a601280a@phx.gbl...
: >: Hi
: >: I'm trying to update time field which MSACCESS using
: query
: >:
: >: Sql2 = "Update tblExtraNetUsers SET Lo_date = " & Date
: ()
: >: & ",Lo_time =#" & FormatDateTime(Time(),4)
: &"# ,Lo_count
: >: = " & rs("Lo_count") + 1 & " WHERE UserLogOn = 'david'"
: >:
: >: But its always gives a error message
: >: Operation must use an updateable query.
: >:
: >: Thanx at advance
: >
: >
: >.
: >