2 things 1. This is an access permission problems 2. Access permission problems and other issues should not result in Yellow Screen of Death. Use Try/Catch/Finally to do proper error handling.
http://www.learnasp.com/freebook/learn/cs_dbtable.aspx (C#) http://www.learnasp.com/freebook/learn/dbopen.aspx (VB.net) shows the basic structure of TRY/CATCH/FINALLY and good connection closing best practices as well. On Sun, 23 Jan 2005 04:50:26 -0800 (PST), Julio Andrew <[EMAIL PROTECTED]> wrote: > > Dear friends > > I have a problem when I try to inputing data to database ??? Please help me > to fix the problem ??? I have already read any books but the problem was > same as before ??? Did any settings problem with my computer ??? The > database I used was Microsoft Access ( Microsoft Jet oledb 4.0 ) > > I send the error message in attach file OK ???? > > Kind regards, Julio > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > ---------- > > Server Error in '/' Application. > -------------------------------------------------------------------------------- > > Operation must use an updateable query. > Description: An unhandled exception occurred during the execution of the > current web request. Please review the stack trace for more information > about the error and where it originated in the code. > > Exception Details: System.Data.OleDb.OleDbException: Operation must use an > updateable query. > > Source Error: > > > Line 20: response.write (Updatestring) > Line 21: > Line 22: myCommand.Executenonquery() > Line 23: > Line 24: myConnection.Close() > > > Source File: d:\inetpub\wwwroot\Update.aspx Line: 22 > > Stack Trace: > > > [OleDbException (0x80004005): Operation must use an updateable query.] > System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) > +41 > > System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS > dbParams, Object& executeResult) +174 > System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) > +92 > System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, > Object& executeResult) +65 > System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior > behavior, String method) +112 > System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +67 > ASP.Update_aspx.Page_Load(Object Sender, EventArgs E) in > d:\inetpub\wwwroot\Update.aspx:22 > System.Web.UI.Control.OnLoad(EventArgs e) +67 > System.Web.UI.Control.LoadRecursive() +35 > System.Web.UI.Page.ProcessRequestMain() +731 > > > > > -------------------------------------------------------------------------------- > Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET > Version:1.1.4322.573 > > [Non-text portions of this message have been removed] > > > > > > ________________________________ > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
