title: ASP.NET using an Access database
body: <p>I am trying to create an Online CV and have stored all the info into an Access DB, I need help with this below error I get when I use an ASP button to create a label and then try to use the label to find the relevant info in te DB.</p>
  
  <p>Below is my error</p>
  
  <blockquote>
    <h2>Server Error in '/Interactive CV' Application.</h2>
    
    <p>Syntax error in FROM clause.    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. </p>
    
    <p>Exception Details: System.Data.OleDb.OleDbException: Syntax error in
    FROM clause.</p>
    
    <p>Source Error: </p>
    
    <p>Line 81:                 conn.Open() Line 82:                 'Declare
    an OleDbDataReader to read the data in the database Line 83:<br>
    Using myReader As OleDbDataReader = myCommand.ExecuteReader() Line 84:
    myReader.Read() Line 85:                     'Create a label          </p>
    
    <p>Source File:  C:\Users\user\Desktop\Uni Final Module\Interactive
    CV\File.aspx.vb    Line:  83 </p>
    
    <p>Stack Trace: </p>
    
    <p>[OleDbException (0x80040e14): Syntax error in FROM clause.]<br>
    System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult
    hr) +1081708<br>
    System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
    dbParams, Object&amp; executeResult) +247<br>
    System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object&amp;
    executeResult) +194<br>
    System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior
    behavior, Object&amp; executeResult) +58<br>
    System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
    behavior, String method) +167<br>
    System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
    +116    System.Data.OleDb.OleDbCommand.ExecuteReader() +6    File.createContent(String e) in C:\Users\user\Desktop\Uni Final
    Module\Interactive CV\File.aspx.vb:83    File.btnContent_Click(Object
    sender, EventArgs e) in C:\Users\user\Desktop\Uni Final
    Module\Interactive CV\File.aspx.vb:51<br>
    System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118<br>
    System.Web.UI.WebControls.Button.RaisePostBackEvent(String
    eventArgument) +112<br>
    System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String
    eventArgument) +10<br>
    System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
    sourceControl, String eventArgument) +13<br>
    System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
    +36    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    +5563</p>
  </blockquote>
  
  <hr>
  
  <p>Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272 </p>