asked on

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!

hhammash

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

chapstickMan

ASKER

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!


<%
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">


<script Language="JavaScript">

</script>


<% 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
%>



<p></p>



</body>

</html>

chapstickMan

ASKER

Any Ideas? I need help!!

seanpowell

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

chapstickMan

ASKER

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>
            
<% 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
%>


</tbody>
</table>

</body>

</html>

hhammash

Hi,

Try putting:

WHERE (student_key = ::student_key::)

hhammash

ASKER CERTIFIED SOLUTION

coreybryant

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial