title: Inserting new record into ACCESS with ASP - issue with parameters
body: <p>I have created a simple ASP page in Expression Web 4 and have a textbox  to ask end user for an activity. I am trying to insert the entered activity name into an access database using ASP.Net connections.</p>
  
  <p>When I load the webpage and enter a value in the textbox...and hit refresh, it won't send the entered value to ACCESS. </p>
  
  <p>The Database is called '<strong>BookingDB</strong>'.  The table is called '<strong>tbl_Booking</strong>'.
  Two fields exist therein (Fields: Customer and Activity)</p>
  
  <p><strong><em>Customer</em></strong>: <em>PK</em> and <em>Autonumber</em>.</p>
  
  <p><strong><em>Activity</em></strong>: <em>Short Text</em>.</p>
  
  <p>On Webpage, the textbox is named <strong>txtActivity</strong>.</p>
  
  <pre><code>    &lt;form id="form1" runat="server"&gt;
      &lt;p&gt;
      &lt;asp:TextBox id="txtActivity" runat="server" Height="29px" Width="153px"&gt;&lt;/asp:TextBox&gt;
      &lt;asp:AccessDataSource id="AccessDataSource3" runat="server" DataFile="BookingDB.mdb" SelectCommand="INSERT INTO [tbl_Booking] ([Activity]) VALUES (?)"&gt;
          &lt;SelectParameters&gt;
              &lt;asp:ControlParameter ControlID="txtActivity" Name="Act_Parameter" PropertyName="Text" /&gt;
          &lt;/SelectParameters&gt;
      &lt;/asp:AccessDataSource&gt;
      &lt;/p&gt;
  &lt;/form&gt;
  </code></pre>