I've been asked to create a web form to edit a couple of fields in one record in an Access database. The database is on the same server as the website.
This is part of a simple CMS that someone developed a long time ago in traditional ASP with VB. I don't know VB well and am trying to get something working by adapting the existing code used in the CMS. I can get the form to display the current values in the record (there are only two fields that need to be edited), but I can't get the form to successfully update the record when the user clicks the submit button. I'm sure the solution is simple but I've googled up down and sideways and can't seem to get this to work. If anybody with a little patience has a minute to look at this and offer a solution, I'd be grateful.
Here's a link to the page in questsion:
http://www.penobscotbayinn.com/admin/AdminFrameDefault.asp (click on "edit rates page text") on the menu.
If you submit the form you get a HTTP500 error.
Thanks for your time. This seems like it must be a dirt simple procedure, but I'm not very conversant in VB.Here's the code: 1. <%@ Language=VBScript %>
2. <% option Explicit %>
3. <% 'Response.Buffer = true %>
4. <!--#include file="../adovbs.inc"-->
5. <!--#include fi
View Complete Post