Can't do an update query into Access from FrontPage

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!
chapstickManAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

hhammashCommented:
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
chapstickManAuthor Commented:
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
chapstickManAuthor Commented:
Any Ideas? I need help!!
0
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

seanpowellCommented:
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
chapstickManAuthor Commented:
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
hhammashCommented:
Hi,

Try putting:

WHERE (student_key =  ::student_key::)

hhammash
0
coreybryantCommented:
force accept
coreybryant
FP Page Editor
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.