Operation must use an updateable query error.

hiye guys, can anyone tell me whats wrong with this piece
of code? to my knowledge, its looks and seems fine. i'm
very puzzle by this error.
i get this error msg
"Operation must use an updateable query."
anyone knows what it means?

below is the code

Line 31: objCommand = New OleDbCommand("INSERT
INTO DailyUpdates(content) VALUES('HELLO')", objConn)
Line 32: objCommand.Connection.Open()
error here --> Line 33: objCommand.ExecuteNonQuery
()
Line 34: objCommand.Connection.Close()
Line 35: End Sub

yours truly.

mamakIf you are using Access as your database, it usually means that the ASPNET
account doesn't have sufficient permissions to the directory where the .mdb
file is located. Access needs to create a lock file (.ldb) so the ASPNET
account needs at least write permissions and maybe full control.

"abdul haleem" <mamak@.hotmail.com> wrote in message
news:006f01c395f6$807dd710$a001280a@.phx.gbl...
hiye guys, can anyone tell me whats wrong with this piece
of code? to my knowledge, its looks and seems fine. i'm
very puzzle by this error.
i get this error msg
"Operation must use an updateable query."
anyone knows what it means?

below is the code

Line 31: objCommand = New OleDbCommand("INSERT
INTO DailyUpdates(content) VALUES('HELLO')", objConn)
Line 32: objCommand.Connection.Open()
error here --> Line 33: objCommand.ExecuteNonQuery
()
Line 34: objCommand.Connection.Close()
Line 35: End Sub

yours truly.

mamak
and how is that?
i'm pretty new to .net.
>--Original Message--
>If you are using Access as your database, it usually
means that the ASPNET
>account doesn't have sufficient permissions to the
directory where the .mdb
>file is located. Access needs to create a lock file
(.ldb) so the ASPNET
>account needs at least write permissions and maybe full
control.
>
>"abdul haleem" <mamak@.hotmail.com> wrote in message
>news:006f01c395f6$807dd710$a001280a@.phx.gbl...
>hiye guys, can anyone tell me whats wrong with this piece
>of code? to my knowledge, its looks and seems fine. i'm
>very puzzle by this error.
>i get this error msg
>"Operation must use an updateable query."
>anyone knows what it means?
>below is the code
>
>Line 31: objCommand = New OleDbCommand("INSERT
>INTO DailyUpdates(content) VALUES('HELLO')", objConn)
>Line 32: objCommand.Connection.Open()
>error here --> Line 33: objCommand.ExecuteNonQuery
>()
>Line 34: objCommand.Connection.Close()
>Line 35: End Sub
>
>yours truly.
>mamak
>
>.
If you are using Access as your database, it usually means that the ASPNET
account doesn't have sufficient permissions to the directory where the .mdb
file is located. Access needs to create a lock file (.ldb) so the ASPNET
account needs at least write permissions and maybe full control.

"abdul haleem" <mamak@.hotmail.com> wrote in message
news:006f01c395f6$807dd710$a001280a@.phx.gbl...
hiye guys, can anyone tell me whats wrong with this piece
of code? to my knowledge, its looks and seems fine. i'm
very puzzle by this error.
i get this error msg
"Operation must use an updateable query."
anyone knows what it means?

below is the code

Line 31: objCommand = New OleDbCommand("INSERT
INTO DailyUpdates(content) VALUES('HELLO')", objConn)
Line 32: objCommand.Connection.Open()
error here --> Line 33: objCommand.ExecuteNonQuery
()
Line 34: objCommand.Connection.Close()
Line 35: End Sub

yours truly.

mamak
and how is that?
i'm pretty new to .net.
>--Original Message--
>If you are using Access as your database, it usually
means that the ASPNET
>account doesn't have sufficient permissions to the
directory where the .mdb
>file is located. Access needs to create a lock file
(.ldb) so the ASPNET
>account needs at least write permissions and maybe full
control.
>
>"abdul haleem" <mamak@.hotmail.com> wrote in message
>news:006f01c395f6$807dd710$a001280a@.phx.gbl...
>hiye guys, can anyone tell me whats wrong with this piece
>of code? to my knowledge, its looks and seems fine. i'm
>very puzzle by this error.
>i get this error msg
>"Operation must use an updateable query."
>anyone knows what it means?
>below is the code
>
>Line 31: objCommand = New OleDbCommand("INSERT
>INTO DailyUpdates(content) VALUES('HELLO')", objConn)
>Line 32: objCommand.Connection.Open()
>error here --> Line 33: objCommand.ExecuteNonQuery
>()
>Line 34: objCommand.Connection.Close()
>Line 35: End Sub
>
>yours truly.
>mamak
>
>.
Like Oliver suggested - grant the correct permissions to the .mdb file for the ASP.NET worker process account.

More info here: http://support.microsoft.com/suppor...&NoWebContent=1

Cheers,
Wim Hollebrandse
http://www.wimdows.net
http://www.wimdows.com

--
Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/
Like Oliver suggested - grant the correct permissions to the .mdb file for the ASP.NET worker process account.

More info here: http://support.microsoft.com/suppor...&NoWebContent=1

Cheers,
Wim Hollebrandse
http://www.wimdows.net
http://www.wimdows.com

--
Posted using Wimdows.net Newsgroups - http://www.wimdows.net/newsgroups/