Solved

Can't do an update query into Access from FrontPage

Posted on 2003-11-23
8
322 Views
Last Modified: 2013-12-24
I have a page that pulls results from my database just fine.

However, when I try to do update queries, it keeps saying this:

Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator.

However, when I make frontpages silly NorthWind example database, it let's me update that database.

I am completely lost how I can solve this problem. The pages are asp.

Thanks!
0
Comment
Question by:chapstickMan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
8 Comments
 
LVL 14

Expert Comment

by:hhammash
ID: 9806066
Hi,

Are you sure that you have permissions to write to the database on the server?  If you don't have permissions you won't be able to do it.

If you do have permissions,  would you please post your SQL here?

Thanks
hhammash
0
 

Author Comment

by:chapstickMan
ID: 9807193
Hi:

Can you tell me exactly where I'd need to set the permissions? Would I do that inside IIS or would I just right click on the certain file(s)? I tried comparing the northwind sample database with mine, and couldn't find any different permissions set, and that one works.

Here is the code for my update.asp page.  (Sorry if it's so much, it's a rather large form)

Thanks for your help!

<!--#include File='login.asa'-->
<%
    If Session(SiteID) <> true Then
        Response.Redirect("Login.asp?requester=update.asp")
    End If
%>


<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Results -- Updated Record</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>

<body bgcolor="#FFFFFF">
<!--webbot bot="PurpleText" PREVIEW="-Important-  If you modify this Database Results region using the Database Results Wizard, then your Database Editor will no longer work.  If you accidentally open the Database Results Wizard, simply click Cancel to exit without regenerating the Database Results region." -->

<script Language="JavaScript">
<!--
      top.list.location.href = top.list.location.href;
// -->
</script>

<!--webbot bot="DatabaseRegionStart" s-columnnames="Key,FirstName,LastName,SocialSecurity,Birthday,Sex,Sport,Advisor,ClassLevel,PhoneNumber,email,A1,A2,A3_Father,A3_Mother,A3_Sibling,A3_Children,A3_Other,A4,Adopted,FirstGen,B1,B2,B3,B4,C1head,C1diab,C1Seiz,C1conc,C1unco,C1ear,C1vision,C1hear,C1stroke,C1asth,C1aller,C1fever,C1drown,C1other,C2,C3,C4,C5,C6,C7,S1,C8,C9,C10,C11,C12,C13,C14,C15,C16,C17,D1math,D1verbal,D2,D3,D4elm,D4ept,D4mp,D4twa,D5,D6,D7spec,D7phys,D7limit,D7emoti,D7econ,D7manag,D7task,D7home,D7lack,D7bad,D7poor,D7other,D8,D9anxi,D9true,D9short,D9spell,D9memo,D9comp,D9insuff,D9match,D9long,D9gram,D9back,D9mult,D9fill,D9calc,D9organ,D9dist,E1,E2,E3,E4,E5,E6under,E6itegr,E6loca,E6read,E7,F1add,F1mult,F1time,F1manag,F1geom,F1subt,F1divis,F1money,F1meas,F2,F3,G1,G2,G3,G4,G5,H1verb,H1lect,H1misinterp,H2,H3,H4misinterp1,H4misinterp2,H4misinterp3,I1,I2get,I2go,I2becom,I2bud,I2stic,I2test,I2blurt,I2shift,I2bein,I2list,I2act,I2lack,I2mak,I2under,I2fid,I2wait,I2foll,I2sust,I2exces,I2inter,I2losi,I2other,I3,I4,C101,C161,C18,C19,C20in,C20priv,C20opto,C20alco,C20relax,C20other,C21,D4,D7elm,D7ept,D7mp,D7twa,D9,D10,D11spec,D11phys,D11limit,D11emoti,D11econ,D11manag,D11task,D11home,D11lack,D11bad,D11poor,D11other,D12,D13anxi,D13true,D13short,D13spell,D13memo,D13comp,D13insuff,D13match,D13long,D13gram,D13back,D13mult,D13fill,D13calc,D13organ,D13dist" s-columntypes="3,202,202,202,202,202,202,202,202,202,202,203,203,202,202,202,202,202,203,202,202,203,203,203,203,202,202,202,202,202,202,202,202,202,202,202,202,202,202,203,202,203,202,203,202,203,203,202,202,202,203,202,203,202,202,203,202,202,203,202,202,202,202,202,202,203,202,202,202,202,202,202,202,202,202,202,202,202,203,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,203,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,203,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,203,203,203,203,202,203,202,202,202,202,202,202,203,203,202,202,202,202,203,203,202,202,202,202,202,202,202,202,202,202,202,202,203,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202" s-dataconnection="eea" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="FALSE" b-listseparator="FALSE" i-ListFormat="0" b-makeform="FALSE" s-RecordSource s-displaycolumns s-criteria s-order s-sql="UPDATE Results SET FirstName = '::FirstName::' , LastName = '::LastName::' , SocialSecurity = '::SocialSecurity::' , Birthday = '::Birthday::' , Sex = '::Sex::' , Sport = '::Sport::' , Advisor = '::Advisor::' , ClassLevel = '::ClassLevel::' , PhoneNumber = '::PhoneNumber::' , email = '::email::' , A1 = '::A1::' , A2 = '::A2::' , A3_Father = '::A3_Father::' , A3_Mother = '::A3_Mother::' , A3_Sibling = '::A3_Sibling::' , A3_Children = '::A3_Children::' , A3_Other = '::A3_Other::' , A4 = '::A4::' , Adopted = '::Adopted::' , FirstGen = '::FirstGen::' , B1 = '::B1::' , B2 = '::B2::' , B3 = '::B3::' , B4 = '::B4::' , C1head = '::C1head::' , C1diab = '::C1diab::' , C1Seiz = '::C1Seiz::' , C1conc = '::C1conc::' , C1unco = '::C1unco::' , C1ear = '::C1ear::' , C1vision = '::C1vision::' , C1hear = '::C1hear::' , C1stroke = '::C1stroke::' , C1asth = '::C1asth::' , C1aller = '::C1aller::' , C1fever = '::C1fever::' , C1drown = '::C1drown::' , C1other = '::C1other::' , C2 = '::C2::' , C3 = '::C3::' , C4 = '::C4::' , C5 = '::C5::' , C6 = '::C6::' , C7 = '::C7::' , S1 = '::S1::' , C8 = '::C8::' , C9 = '::C9::' , C10 = '::C10::' , C11 = '::C11::' , C12 = '::C12::' , C13 = '::C13::' , C14 = '::C14::' , C15 = '::C15::' , C16 = '::C16::' , C17 = '::C17::' , D1math = '::D1math::' , D1verbal = '::D1verbal::' , D2 = '::D2::' , D3 = '::D3::' , D4elm = '::D4elm::' , D4ept = '::D4ept::' , D4mp = '::D4mp::' , D4twa = '::D4twa::' , D5 = '::D5::' , D6 = '::D6::' , D7spec = '::D7spec::' , D7phys = '::D7phys::' , D7limit = '::D7limit::' , D7emoti = '::D7emoti::' , D7econ = '::D7econ::' , D7manag = '::D7manag::' , D7task = '::D7task::' , D7home = '::D7home::' , D7lack = '::D7lack::' , D7bad = '::D7bad::' , D7poor = '::D7poor::' , D7other = '::D7other::' , D8 = '::D8::' , D9anxi = '::D9anxi::' , D9true = '::D9true::' , D9short = '::D9short::' , D9spell = '::D9spell::' , D9memo = '::D9memo::' , D9comp = '::D9comp::' , D9insuff = '::D9insuff::' , D9match = '::D9match::' , D9long = '::D9long::' , D9gram = '::D9gram::' , D9back = '::D9back::' , D9mult = '::D9mult::' , D9fill = '::D9fill::' , D9calc = '::D9calc::' , D9organ = '::D9organ::' , D9dist = '::D9dist::' , E1 = '::E1::' , E2 = '::E2::' , E3 = '::E3::' , E4 = '::E4::' , E5 = '::E5::' , E6under = '::E6under::' , E6itegr = '::E6itegr::' , E6loca = '::E6loca::' , E6read = '::E6read::' , E7 = '::E7::' , F1add = '::F1add::' , F1mult = '::F1mult::' , F1time = '::F1time::' , F1manag = '::F1manag::' , F1geom = '::F1geom::' , F1subt = '::F1subt::' , F1divis = '::F1divis::' , F1money = '::F1money::' , F1meas = '::F1meas::' , F2 = '::F2::' , F3 = '::F3::' , G1 = '::G1::' , G2 = '::G2::' , G3 = '::G3::' , G4 = '::G4::' , G5 = '::G5::' , H1verb = '::H1verb::' , H1lect = '::H1lect::' , H1misinterp = '::H1misinterp::' , H2 = '::H2::' , H3 = '::H3::' , H4misinterp1 = '::H4misinterp1::' , H4misinterp2 = '::H4misinterp2::' , H4misinterp3 = '::H4misinterp3::' , I1 = '::I1::' , I2get = '::I2get::' , I2go = '::I2go::' , I2becom = '::I2becom::' , I2bud = '::I2bud::' , I2stic = '::I2stic::' , I2test = '::I2test::' , I2blurt = '::I2blurt::' , I2shift = '::I2shift::' , I2bein = '::I2bein::' , I2list = '::I2list::' , I2act = '::I2act::' , I2lack = '::I2lack::' , I2mak = '::I2mak::' , I2under = '::I2under::' , I2fid = '::I2fid::' , I2wait = '::I2wait::' , I2foll = '::I2foll::' , I2sust = '::I2sust::' , I2exces = '::I2exces::' , I2inter = '::I2inter::' , I2losi = '::I2losi::' , I2other = '::I2other::' , I3 = '::I3::' , I4 = '::I4::' , C101 = '::C101::' , C161 = '::C161::' , C18 = '::C18::' , C19 = '::C19::' , C20in = '::C20in::' , C20priv = '::C20priv::' , C20opto = '::C20opto::' , C20alco = '::C20alco::' , C20relax = '::C20relax::' , C20other = '::C20other::' , C21 = '::C21::' , D4 = '::D4::' , D7elm = '::D7elm::' , D7ept = '::D7ept::' , D7mp = '::D7mp::' , D7twa = '::D7twa::' , D9 = '::D9::' , D10 = '::D10::' , D11spec = '::D11spec::' , D11phys = '::D11phys::' , D11limit = '::D11limit::' , D11emoti = '::D11emoti::' , D11econ = '::D11econ::' , D11manag = '::D11manag::' , D11task = '::D11task::' , D11home = '::D11home::' , D11lack = '::D11lack::' , D11bad = '::D11bad::' , D11poor = '::D11poor::' , D11other = '::D11other::' , D12 = '::D12::' , D13anxi = '::D13anxi::' , D13true = '::D13true::' , D13short = '::D13short::' , D13spell = '::D13spell::' , D13memo = '::D13memo::' , D13comp = '::D13comp::' , D13insuff = '::D13insuff::' , D13match = '::D13match::' , D13long = '::D13long::' , D13gram = '::D13gram::' , D13back = '::D13back::' , D13mult = '::D13mult::' , D13fill = '::D13fill::' , D13calc = '::D13calc::' , D13organ = '::D13organ::' , D13dist = '::D13dist::'  WHERE (Key = ::Key::)" b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields="FirstName=&LastName=&SocialSecurity=&Birthday=&Sex=&Sport=&Advisor=&ClassLevel=&PhoneNumber=&email=&A1=&A2=&A3_Father=&A3_Mother=&A3_Sibling=&A3_Children=&A3_Other=&A4=&Adopted=&FirstGen=&B1=&B2=&B3=&B4=&C1head=&C1diab=&C1Seiz=&C1conc=&C1unco=&C1ear=&C1vision=&C1hear=&C1stroke=&C1asth=&C1aller=&C1fever=&C1drown=&C1other=&C2=&C3=&C4=&C5=&C6=&C7=&S1=&C8=&C9=&C10=&C11=&C12=&C13=&C14=&C15=&C16=&C17=&D1math=&D1verbal=&D2=&D3=&D4elm=&D4ept=&D4mp=&D4twa=&D5=&D6=&D7spec=&D7phys=&D7limit=&D7emoti=&D7econ=&D7manag=&D7task=&D7home=&D7lack=&D7bad=&D7poor=&D7other=&D8=&D9anxi=&D9true=&D9short=&D9spell=&D9memo=&D9comp=&D9insuff=&D9match=&D9long=&D9gram=&D9back=&D9mult=&D9fill=&D9calc=&D9organ=&D9dist=&E1=&E2=&E3=&E4=&E5=&E6under=&E6itegr=&E6loca=&E6read=&E7=&F1add=&F1mult=&F1time=&F1manag=&F1geom=&F1subt=&F1divis=&F1money=&F1meas=&F2=&F3=&G1=&G2=&G3=&G4=&G5=&H1verb=&H1lect=&H1misinterp=&H2=&H3=&H4misinterp1=&H4misinterp2=&H4misinterp3=&I1=&I2get=&I2go=&I2becom=&I2bud=&I2stic=&I2test=&I2blurt=&I2shift=&I2bein=&I2list=&I2act=&I2lack=&I2mak=&I2under=&I2fid=&I2wait=&I2foll=&I2sust=&I2exces=&I2inter=&I2losi=&I2other=&I3=&I4=&C101=&C161=&C18=&C19=&C20in=&C20priv=&C20opto=&C20alco=&C20relax=&C20other=&C21=&D4=&D7elm=&D7ept=&D7mp=&D7twa=&D9=&D10=&D11spec=&D11phys=&D11limit=&D11emoti=&D11econ=&D11manag=&D11task=&D11home=&D11lack=&D11bad=&D11poor=&D11other=&D12=&D13anxi=&D13true=&D13short=&D13spell=&D13memo=&D13comp=&D13insuff=&D13match=&D13long=&D13gram=&D13back=&D13mult=&D13fill=&D13calc=&D13organ=&D13dist=&Key=0" s-NoRecordsFound="Record updated in table." i-MaxRecords="1" i-GroupSize="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" Tag="BODY" startspan BOTID="0" preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" --><!--#include file="../../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="UPDATE Results SET FirstName = '::FirstName::' , LastName = '::LastName::' , SocialSecurity = '::SocialSecurity::' , Birthday = '::Birthday::' , Sex = '::Sex::' , Sport = '::Sport::' , Advisor = '::Advisor::' , ClassLevel = '::ClassLevel::' , PhoneNumber = '::PhoneNumber::' , email = '::email::' , A1 = '::A1::' , A2 = '::A2::' , A3_Father = '::A3_Father::' , A3_Mother = '::A3_Mother::' , A3_Sibling = '::A3_Sibling::' , A3_Children = '::A3_Children::' , A3_Other = '::A3_Other::' , A4 = '::A4::' , Adopted = '::Adopted::' , FirstGen = '::FirstGen::' , B1 = '::B1::' , B2 = '::B2::' , B3 = '::B3::' , B4 = '::B4::' , C1head = '::C1head::' , C1diab = '::C1diab::' , C1Seiz = '::C1Seiz::' , C1conc = '::C1conc::' , C1unco = '::C1unco::' , C1ear = '::C1ear::' , C1vision = '::C1vision::' , C1hear = '::C1hear::' , C1stroke = '::C1stroke::' , C1asth = '::C1asth::' , C1aller = '::C1aller::' , C1fever = '::C1fever::' , C1drown = '::C1drown::' , C1other = '::C1other::' , C2 = '::C2::' , C3 = '::C3::' , C4 = '::C4::' , C5 = '::C5::' , C6 = '::C6::' , C7 = '::C7::' , S1 = '::S1::' , C8 = '::C8::' , C9 = '::C9::' , C10 = '::C10::' , C11 = '::C11::' , C12 = '::C12::' , C13 = '::C13::' , C14 = '::C14::' , C15 = '::C15::' , C16 = '::C16::' , C17 = '::C17::' , D1math = '::D1math::' , D1verbal = '::D1verbal::' , D2 = '::D2::' , D3 = '::D3::' , D4elm = '::D4elm::' , D4ept = '::D4ept::' , D4mp = '::D4mp::' , D4twa = '::D4twa::' , D5 = '::D5::' , D6 = '::D6::' , D7spec = '::D7spec::' , D7phys = '::D7phys::' , D7limit = '::D7limit::' , D7emoti = '::D7emoti::' , D7econ = '::D7econ::' , D7manag = '::D7manag::' , D7task = '::D7task::' , D7home = '::D7home::' , D7lack = '::D7lack::' , D7bad = '::D7bad::' , D7poor = '::D7poor::' , D7other = '::D7other::' , D8 = '::D8::' , D9anxi = '::D9anxi::' , D9true = '::D9true::' , D9short = '::D9short::' , D9spell = '::D9spell::' , D9memo = '::D9memo::' , D9comp = '::D9comp::' , D9insuff = '::D9insuff::' , D9match = '::D9match::' , D9long = '::D9long::' , D9gram = '::D9gram::' , D9back = '::D9back::' , D9mult = '::D9mult::' , D9fill = '::D9fill::' , D9calc = '::D9calc::' , D9organ = '::D9organ::' , D9dist = '::D9dist::' , E1 = '::E1::' , E2 = '::E2::' , E3 = '::E3::' , E4 = '::E4::' , E5 = '::E5::' , E6under = '::E6under::' , E6itegr = '::E6itegr::' , E6loca = '::E6loca::' , E6read = '::E6read::' , E7 = '::E7::' , F1add = '::F1add::' , F1mult = '::F1mult::' , F1time = '::F1time::' , F1manag = '::F1manag::' , F1geom = '::F1geom::' , F1subt = '::F1subt::' , F1divis = '::F1divis::' , F1money = '::F1money::' , F1meas = '::F1meas::' , F2 = '::F2::' , F3 = '::F3::' , G1 = '::G1::' , G2 = '::G2::' , G3 = '::G3::' , G4 = '::G4::' , G5 = '::G5::' , H1verb = '::H1verb::' , H1lect = '::H1lect::' , H1misinterp = '::H1misinterp::' , H2 = '::H2::' , H3 = '::H3::' , H4misinterp1 = '::H4misinterp1::' , H4misinterp2 = '::H4misinterp2::' , H4misinterp3 = '::H4misinterp3::' , I1 = '::I1::' , I2get = '::I2get::' , I2go = '::I2go::' , I2becom = '::I2becom::' , I2bud = '::I2bud::' , I2stic = '::I2stic::' , I2test = '::I2test::' , I2blurt = '::I2blurt::' , I2shift = '::I2shift::' , I2bein = '::I2bein::' , I2list = '::I2list::' , I2act = '::I2act::' , I2lack = '::I2lack::' , I2mak = '::I2mak::' , I2under = '::I2under::' , I2fid = '::I2fid::' , I2wait = '::I2wait::' , I2foll = '::I2foll::' , I2sust = '::I2sust::' , I2exces = '::I2exces::' , I2inter = '::I2inter::' , I2losi = '::I2losi::' , I2other = '::I2other::' , I3 = '::I3::' , I4 = '::I4::' , C101 = '::C101::' , C161 = '::C161::' , C18 = '::C18::' , C19 = '::C19::' , C20in = '::C20in::' , C20priv = '::C20priv::' , C20opto = '::C20opto::' , C20alco = '::C20alco::' , C20relax = '::C20relax::' , C20other = '::C20other::' , C21 = '::C21::' , D4 = '::D4::' , D7elm = '::D7elm::' , D7ept = '::D7ept::' , D7mp = '::D7mp::' , D7twa = '::D7twa::' , D9 = '::D9::' , D10 = '::D10::' , D11spec = '::D11spec::' , D11phys = '::D11phys::' , D11limit = '::D11limit::' , D11emoti = '::D11emoti::' , D11econ = '::D11econ::' , D11manag = '::D11manag::' , D11task = '::D11task::' , D11home = '::D11home::' , D11lack = '::D11lack::' , D11bad = '::D11bad::' , D11poor = '::D11poor::' , D11other = '::D11other::' , D12 = '::D12::' , D13anxi = '::D13anxi::' , D13true = '::D13true::' , D13short = '::D13short::' , D13spell = '::D13spell::' , D13memo = '::D13memo::' , D13comp = '::D13comp::' , D13insuff = '::D13insuff::' , D13match = '::D13match::' , D13long = '::D13long::' , D13gram = '::D13gram::' , D13back = '::D13back::' , D13mult = '::D13mult::' , D13fill = '::D13fill::' , D13calc = '::D13calc::' , D13organ = '::D13organ::' , D13dist = '::D13dist::'  WHERE (Key = ::Key::)"
fp_sDefault="FirstName=&LastName=&SocialSecurity=&Birthday=&Sex=&Sport=&Advisor=&ClassLevel=&PhoneNumber=&email=&A1=&A2=&A3_Father=&A3_Mother=&A3_Sibling=&A3_Children=&A3_Other=&A4=&Adopted=&FirstGen=&B1=&B2=&B3=&B4=&C1head=&C1diab=&C1Seiz=&C1conc=&C1unco=&C1ear=&C1vision=&C1hear=&C1stroke=&C1asth=&C1aller=&C1fever=&C1drown=&C1other=&C2=&C3=&C4=&C5=&C6=&C7=&S1=&C8=&C9=&C10=&C11=&C12=&C13=&C14=&C15=&C16=&C17=&D1math=&D1verbal=&D2=&D3=&D4elm=&D4ept=&D4mp=&D4twa=&D5=&D6=&D7spec=&D7phys=&D7limit=&D7emoti=&D7econ=&D7manag=&D7task=&D7home=&D7lack=&D7bad=&D7poor=&D7other=&D8=&D9anxi=&D9true=&D9short=&D9spell=&D9memo=&D9comp=&D9insuff=&D9match=&D9long=&D9gram=&D9back=&D9mult=&D9fill=&D9calc=&D9organ=&D9dist=&E1=&E2=&E3=&E4=&E5=&E6under=&E6itegr=&E6loca=&E6read=&E7=&F1add=&F1mult=&F1time=&F1manag=&F1geom=&F1subt=&F1divis=&F1money=&F1meas=&F2=&F3=&G1=&G2=&G3=&G4=&G5=&H1verb=&H1lect=&H1misinterp=&H2=&H3=&H4misinterp1=&H4misinterp2=&H4misinterp3=&I1=&I2get=&I2go=&I2becom=&I2bud=&I2stic=&I2test=&I2blurt=&I2shift=&I2bein=&I2list=&I2act=&I2lack=&I2mak=&I2under=&I2fid=&I2wait=&I2foll=&I2sust=&I2exces=&I2inter=&I2losi=&I2other=&I3=&I4=&C101=&C161=&C18=&C19=&C20in=&C20priv=&C20opto=&C20alco=&C20relax=&C20other=&C21=&D4=&D7elm=&D7ept=&D7mp=&D7twa=&D9=&D10=&D11spec=&D11phys=&D11limit=&D11emoti=&D11econ=&D11manag=&D11task=&D11home=&D11lack=&D11bad=&D11poor=&D11other=&D12=&D13anxi=&D13true=&D13short=&D13spell=&D13memo=&D13comp=&D13insuff=&D13match=&D13long=&D13gram=&D13back=&D13mult=&D13fill=&D13calc=&D13organ=&D13dist=&Key=0"
fp_sNoRecords="Record updated in table."
fp_sDataConn="eea"
fp_iMaxRecords=1
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Key=3&FirstName=202&LastName=202&SocialSecurity=202&Birthday=202&Sex=202&Sport=202&Advisor=202&ClassLevel=202&PhoneNumber=202&email=202&A1=203&A2=203&A3_Father=202&A3_Mother=202&A3_Sibling=202&A3_Children=202&A3_Other=202&A4=203&Adopted=202&FirstGen=202&B1=203&B2=203&B3=203&B4=203&C1head=202&C1diab=202&C1Seiz=202&C1conc=202&C1unco=202&C1ear=202&C1vision=202&C1hear=202&C1stroke=202&C1asth=202&C1aller=202&C1fever=202&C1drown=202&C1other=202&C2=203&C3=202&C4=203&C5=202&C6=203&C7=202&S1=203&C8=203&C9=202&C10=202&C11=202&C12=203&C13=202&C14=203&C15=202&C16=202&C17=203&D1math=202&D1verbal=202&D2=203&D3=202&D4elm=202&D4ept=202&D4mp=202&D4twa=202&D5=202&D6=203&D7spec=202&D7phys=202&D7limit=202&D7emoti=202&D7econ=202&D7manag=202&D7task=202&D7home=202&D7lack=202&D7bad=202&D7poor=202&D7other=202&D8=203&D9anxi=202&D9true=202&D9short=202&D9spell=202&D9memo=202&D9comp=202&D9insuff=202&D9match=202&D9long=202&D9gram=202&D9back=202&D9mult=202&D9fill=202&D9calc=202&D9organ=202&D9dist=202&E1=202&E2=203&E3=202&E4=202&E5=202&E6under=202&E6itegr=202&E6loca=202&E6read=202&E7=202&F1add=202&F1mult=202&F1time=202&F1manag=202&F1geom=202&F1subt=202&F1divis=202&F1money=202&F1meas=202&F2=202&F3=202&G1=202&G2=202&G3=202&G4=202&G5=202&H1verb=202&H1lect=202&H1misinterp=202&H2=202&H3=202&H4misinterp1=202&H4misinterp2=202&H4misinterp3=202&I1=203&I2get=202&I2go=202&I2becom=202&I2bud=202&I2stic=202&I2test=202&I2blurt=202&I2shift=202&I2bein=202&I2list=202&I2act=202&I2lack=202&I2mak=202&I2under=202&I2fid=202&I2wait=202&I2foll=202&I2sust=202&I2exces=202&I2inter=202&I2losi=202&I2other=202&I3=203&I4=203&C101=203&C161=203&C18=202&C19=203&C20in=202&C20priv=202&C20opto=202&C20alco=202&C20relax=202&C20other=202&C21=203&D4=203&D7elm=202&D7ept=202&D7mp=202&D7twa=202&D9=203&D10=203&D11spec=202&D11phys=202&D11limit=202&D11emoti=202&D11econ=202&D11manag=202&D11task=202&D11home=202&D11lack=202&D11bad=202&D11poor=202&D11other=202&D12=203&D13anxi=202&D13true=202&D13short=202&D13spell=202&D13memo=202&D13comp=202&D13insuff=202&D13match=202&D13long=202&D13gram=202&D13back=202&D13mult=202&D13fill=202&D13calc=202&D13organ=202&D13dist=202&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="58809" -->

<p><!--webbot bot="PurpleText" PREVIEW="This is the UPDATE query." --></p>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside Tag="BODY" startspan preview="&lt;table border=0 width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td bgcolor=&quot;#FFFF00&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;" --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" -->

</body>

</html>
0
 

Author Comment

by:chapstickMan
ID: 9808206
Any Ideas? I need help!!
0
Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

 
LVL 31

Expert Comment

by:seanpowell
ID: 9810533
One of your field names, "KEY", is a reserved word in Access. Try changing it to something else, like myKEY, etc. and try again.

For reference, here's the complete list:
http://support.microsoft.com:80/support/kb/articles/Q109/3/12.asp&NoWebContent=1
0
 

Author Comment

by:chapstickMan
ID: 9845036
The Key part wasn't a problem. I renamed it. Here is my code. It still gives me the error:

Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator.

Any Ideas? Thanks!


<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>

<body>

<table width="100%" border="1">
      <thead>
      </thead>
      
      <tbody>
            <!--webbot bot="DatabaseRegionStart" s-columnnames s-columntypes s-dataconnection="eea" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns s-criteria s-order s-sql="UPDATE RESULTS&lt;br&gt;SET Firstname = '::FirstName::', Lastname='::LastName::'&lt;br&gt;Where student_key=::student_key::" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="FirstName=&amp;LastName=&amp;student_key=" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="5" botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc" u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include file="_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="UPDATE RESULTS SET Firstname = '::FirstName::', Lastname='::LastName::' Where student_key=::student_key::"
fp_sDefault="FirstName=&LastName=&student_key="
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="eea"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="25422" --><!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="5" clientside tag="TBODY" preview="&lt;tr&gt;&lt;td colspan=64 bgcolor=&quot;#FFFF00&quot; width=&quot;100%&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is the end of a Database Results region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;TR&gt;&lt;TD VALIGN=MIDDLE COLSPAN=64&gt;&lt;NOBR&gt;&lt;INPUT TYPE=Button VALUE=&quot;  |&lt;  &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;   &lt;  &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;  &gt;   &quot;&gt;&lt;INPUT TYPE=Button VALUE=&quot;  &gt;|  &quot;&gt;  [1/5]&lt;/NOBR&gt;&lt;BR&gt;&lt;/td&gt;&lt;/tr&gt;" startspan --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="62730" --></tbody>
</table>

</body>

</html>
0
 
LVL 14

Expert Comment

by:hhammash
ID: 9846905
Hi,

Try putting:

WHERE (student_key =  ::student_key::)

hhammash
0
 
LVL 29

Accepted Solution

by:
coreybryant earned 0 total points
ID: 11089900
force accept
coreybryant
FP Page Editor
0

Featured Post

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
What is the Best Web Design Tool 1 64
Visual Studio Community 2015 vs. Expression Web 4 8 366
Best code editor tool for PC 4 134
Collapseable list of URLs. 10 144
In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
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 exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

751 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