Access Dbase Update Problem?

Discussion in 'Databases' started by Bruce, Apr 3, 2003.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Bruce

    Bruce DiscountASP.NET Staff

    I get an error message saying the following. If you have not already done so, turn off friendly http error on your browser if you are using IE. Tools -> Options -> Advance Tab -> Uncheck Show friendly http error message.

    Microsoft VBScript compilation error '800a03ea'

    Syntax error

    /demo_update.asp, line 23

    else
    ^






    quote:Originally posted by gasounet000

    I use a page named "UpdateTable2.asp" used to display a set of records from an Access Dbase. The file works fine displaying each customers ID, Last Name, First Name, and Last 4 of SS. The attribute button "Custid", when clicked, should allow the user to update a record by calling a file named "demo_update.asp"

    Unfortunately, when the "Custid" button is clicked in the "UpDateTable2.asp" page, the next page reads "The Page Cannot Be Displayed." There seems to be a problem in the "demo_update.asp" page and I can't identify it (hours and hours of trial and error).

    Can anyone help? The URL is gasou.net/UpdateTable2.asp

    The code for both pages follows;

    ****UpDateTable2.asp****
     
    Bruce, Apr 3, 2003
    #1
  2. gasounet000

    gasounet000

    I use a page named "UpdateTable2.asp" used to display a set of records from an Access Dbase. The file works fine displaying each customers ID, Last Name, First Name, and Last 4 of SS. The attribute button "Custid", when clicked, should allow the user to update a record by calling a file named "demo_update.asp"

    Unfortunately, when the "Custid" button is clicked in the "UpDateTable2.asp" page, the next page reads "The Page Cannot Be Displayed." There seems to be a problem in the "demo_update.asp" page and I can't identify it (hours and hours of trial and error).

    Can anyone help? The URL is gasou.net/UpdateTable2.asp

    The code for both pages follows;

    ****UpDateTable2.asp****

     
    gasounet000, Apr 3, 2003
    #2
  3. CreativeLightning

    CreativeLightning

    Change your Custid = to Custid Like

    Access uses Like instead of = as with SQL.

    Hope this helps. :)

    gninthgiLevitaerC
     
    CreativeLightning, Apr 10, 2003
    #3
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page