updating error

[Hlarkin]

When I try to update my database using DRW & an update page. I get the
following. How do I know which Parameter it's talking about.

Database Results Wizard Error
Description: Parameter ?_12 has no default value.
Number: -2147217904 (0x80040E10)
Source: Microsoft JET Database Engine

<%
fp_sQry="UPDATE DOG SET name = '::name::' , sireID = ::sireID:: , damID =
::damID:: , PreTit = ':reTit::' , SuffTit = '::SuffTit::' , callname =
'::callname::' , DOB = ':OB::' , genID = ::genID:: , ColorID = ::ColorID::
, Owner = '::Owner::' , Breeder = '::Breeder::' , DOD = ':OD::' , website =
'::website::' , Hips = '::Hips::' , Eyes = '::Eyes::' , elbows = '::elbows::'
, CNM = '::CNM::' , Honorifics = '::Honorifics::' , UKC = '::UKC::' , AKC =
'::AKC::' WHERE (ID = ::ID:"
fp_sDefault="name=name&sireID=0&damID=0&PreTit=None&SuffTit=None&callname=None&DOB=today()&genID=3&ColorID=4&Owner=Unknown&Breeder=Unknown&DOD=today()&website=unknown&Hips=Unknown&Eyes=Unknown&elbows=Unknown&CNM=unknown&Honorifics=Unknown&UKC=Unknown&AKC=Unknown&ID=0"
fp_sNoRecords="No records returned."
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&AKC=202&UKC=202&Honorifics=202&CNM=202&elbows=202&Eyes=202&Hips=202&website=203&DOD=135&Breeder=202&Owner=202&ColorID=3&genID=3&DOB=135&callname=202&SuffTit=202&PreTit=202&damID=3&sireID=3&name=202&ID=3&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

 

[Kathleen Anderson]

My guess is that is the field called "name" - that is a reserved word in
Access 2002 and in later versions of Access - check this list:
http://support.microsoft.com/default.aspx?scid=kb;en-us;286335 and this
list: http://support.microsoft.com/?id=321266 to make sure you're not
using any others.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others