Update database using Frontpage
Posted on 2004-04-09
I have a table in an MS Access database that I want to update using both visible and hidden fields from a frontpage form. I seem to be able to create the recordset and retrieve the database record to update without a problem. But when I try to update the record I get an error stating "Cannot update the database". I suspect that is happening because frontpage is trying to add a record instead of update the selected record. I have tried using the database results wizard as well a custom query to make this update. I have even taken a shot at using ASP to make this update but can't get it to work either.
This application runs on IIS on a Win 2K server in an intranet environment. I am using frontpage 2000 to build the site.