title: Getting an error when I upload my files to the Internet?
body: <p>Anyone can help I am getting an error when I am trying to register for a user, everything is working fine locally but I am getting an error when I upload my files remotely. Heres my code</p>
  
  <pre><code>    Dim conn As OleDbConnection
      Dim strinsert As String
      Dim cmdinsert As OleDbCommand
  
      conn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|sabersolutions.mdb")
      strinsert = "INSERT INTO register(Name,Email,Passwords,Newsletter,ReportTemplates,ReturningMember,Sponsor)SELECT TOP 1 @Name,@Email,@Passwords,@Newsletter,@ReportTemplates,@ReturningMember,@Sponsor FROM register WHERE NOT EXISTS(SELECT 1 FROM register WHERE Name=@Name AND Email=@Email AND Passwords=@Passwords AND Newsletter=@Newsletter AND ReportTemplates=@ReportTemplates AND ReturningMember=@ReturningMember AND Sponsor=@Sponsor)"
  
      cmdinsert = New OleDbCommand(strinsert, conn)
      cmdinsert.Parameters.Add("@Name", OleDbType.VarWChar, 255).Value = txtName.Text
      cmdinsert.Parameters.Add("@Email", OleDbType.VarWChar, 255).Value = txtEmail.Text
      cmdinsert.Parameters.Add("@Passwords", OleDbType.VarWChar, 255).Value = txtPass.Text
      cmdinsert.Parameters.Add("@Sponsor", OleDbType.Boolean, 1).Value = ckSponsor.Checked
      cmdinsert.Parameters.Add("@Newsletter", OleDbType.Boolean, 1).Value = ckNews.Checked
      cmdinsert.Parameters.Add("@ReportTemplates", OleDbType.Boolean, 1).Value = ckReportTemp.Checked
      cmdinsert.Parameters.Add("@ReturningMember", OleDbType.Boolean, 1).Value = ckRSponsor.Checked
      cmdinsert.Parameters.Add("@Sponsor", OleDbType.Boolean, 1).Value = ckSponsor.Checked
  
      cmdinsert.Connection.Open()
  
      cmdinsert.ExecuteNonQuery()
  
      cmdinsert.Connection.Close()
  
      LblSuccess.Text = "You have successfully Register, Please Login to view our Online Booking Sytem."
  </code></pre>
  
  <p>Error I am getting</p>
  
  <pre><code>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 27:         cmdinsert.Connection.Open()
  Line 28: 
  Line 29:         cmdinsert.ExecuteNonQuery()
  Line 30: 
  Line 31:         cmdinsert.Connection.Close()
  
  Source File: C:\inetpub\vhosts\sabersolutions.co.za\httpdocs\RegisterandLoginForm.aspx.vb    Line: 29 
  </code></pre>
  
  <p>Stack Trace: </p>
  
  <pre><code>   [OleDbException (0x80004005): Operation must use an updateable query.]
     System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +1081356
     System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object&amp; executeResult) +247
     System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object&amp; executeResult) +194
     System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object&amp; executeResult) +58
     System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +167
     System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +113
     RegisterandLoginForm.Button2_Click(Object sender, EventArgs e) in C:\inetpub\vhosts\sabersolutions.co.za\httpdocs\RegisterandLoginForm.aspx.vb:29
     System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
     System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
     System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
     System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
     System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
     System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563
  </code></pre>
  
  <p>Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272</p>