OK it doesn't take a lot to confuse me but...
I have an application up and running - all except a couple of points that I'm working through. One of the things I wanted to do was to create a new page to enable an administrator to check and edit certain fields.
So, in normal edit view I can change the fields in question but if I create a new table view (with only a list page and an edit page) and the try to edit the information I get an error. I can switch back to the main edit page and that still lets me change those same fields.
Where is it (or me) going wrong?
Bob
[codebox]Error number -2147217913
Error description [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
URL /triathlon3/admin/ConfirmPaid_edit.asp
SQL query select * from [TblIndividualEntry] where [ID]=304
Solution The SQL error 80040E07 occurs when attempting to use the "Insert Record" or the "Update Record"
server behavior to set the value of a column in Microsoft Access with an empty string ("").
[/codebox]