Updating a Access mdb database
Posted on 2006-05-10
I am trying ot create a simple sign up list on the web. The dates are already filled out, I just need to have people the other two fields in each row. I plan to use a simple access db to store the data. But for some reason I can't get it to update the db. I tryed to create a seperate page that runs this query
UPDATE Msch SET Provider='%%Provide%%',MenuItem='%%Meal%%' WHERE Date='%%DateSel%%'
and have the entry form send the data to this "update" page. I get this as a result "Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator. "
Is there a way to debug a asp file? Is there an easier way to update a table on access database.
Server is Win2000 running Frontpage 2003. Access 2000 DB file.