Solved

Can't do an update query into Access from FrontPage

Posted on 2003-11-23
8
319 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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 …
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

740 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