how to insert data using accessdatasource in asp.net
<p>I want to insert data using <a href="http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.accessdatasource.aspx" rel="nofollow"><code>AccessDataSource</code></a>.(My database is MS-Access 2007)</p>

<p>My insert statetement is :</p>

<pre><code>INSERT INTO Scrapbook(Username, IP, Time_Stamp, Blog) VALUES (?, ?, ?, ?)
</code></pre>

<p>then I went to Insert query->Command and parameter editor and mapped the paramaters to its corresponding labelboxes and textboxes.</p>

<pre><code>Protected Sub cmdsubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdsubmit.Click
 AccessDataSource2.Insert()
End Sub
</code></pre>

<p>When I execute this from asp.net(ie-through local host), it works fine.</p>

<p>But through network(<code>ie-www.mypage.com</code>) everything works fine but
insert command is not executing.</p>

<blockquote>
  <p>error : <code>Operation must use an updateable query</code></p>
</blockquote>

<p>Thanks in advance</p>
