Updating a Access mdb database

Posted on 2006-05-10
Last Modified: 2013-12-24
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.
Question by:Hunter_boi
    1 Comment
    LVL 2

    Accepted Solution

    lET YOU FORM page action point to a new file that you call update.asp

    In the new file (which will now serve as your confirmation page) do the following. Click on Insert - Database - results - choose your connection and source and select the Custom query radio.
    Type in the SQL statement
    UPDATE Msch
    WHERE ID = ::ID::

    Ok and save - that should do it.

    you will notice that I did not use the date as several entries (if not now in furture) will be the same date that will couse the script to fail. In your Access - create an ID column and make it the Prymary key.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Now that Expression Web 4.0 ( is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
    This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
    The purpose of this video is to demonstrate how to add AdSense Ads to a WordPress Website, and how to set up WordPress to automatically place Ads in Sidebars. This will be demonstrated using a Windows 8 PC. Log into your AdSense account. : Cli…
    The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now