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
Solved

Can't do an update query into Access from FrontPage

Posted on 2003-11-23
8
313 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
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
The purpose of this video is to demonstrate how to automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…

839 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