All my sql commands against Access works fine except my update command.
I had my update command working fine against SQLExpress., but SQLExpress has
other problems.
What am I doing wrong?
Is there another public domain database that I should be using?

   <asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/CUT.mdb"
            SelectCommand="SELECT id,[emailaddress], [firstname],
[lastname], [Coollist] FROM [Email] order by [lastname]"
            UpdateCommand="UPDATE email set
email.firstname=@firstname,email.lastname=@lastname,email.emailaddress=@emailaddress where id=@id"
            DeleteCommand="Delete * from email where id=@id"
            InsertCommand="Insert into email
(firstname,lastname,emailaddress,coollist) values
(@firstname,@lastname,@emailaddress,1)"
Show quoteHide quote

Bulk Inserts with Transaction
the_difference_between_SqlConnection.IDisposable.Disp=ADose()_and_SqlConnection.Dispose()
ODBC connection works, but connection string doesn't
new to .net 2005
How to add new row to typed dataset