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" <an*******@discussions.microsoft.com> wrote in message
news:06****************************@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 accountsufficient privileges to update the database.

Cheers
Ken

"Bhavin" <an*******@discussions.microsoft.com> wrote in messagenews:06****************************@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" <an*******@discussions.microsoft.com> wrote in message
news:04****************************@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" <an*******@discussions.microsoft.com> wrote in
: message
: >news:06****************************@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
: >
: >
: >.
: >