does anyone know what is the maximum number of fields that can be updated at
once in access 2000
i am updating approx. 150 at once and keep getting this error:
Microsoft JET Database Engine error '80004005'
Too many fields defined.

i've seen this error number many times before but never with the "too many
fields defined" in it
here's some code:
MM_fieldsStr =
"guardian1_first|value|guardian1_last|value|guardi an1_license|value|guardian2_first|value|guardian2_ last|value|guardian2_license|val
ue|guardian1_staddress|value|guardian1_city|value| guardian1_state|value|guardian1_zipcode|value|guar dian1_home|value|guardian1_work|
value|guardian1_cell|value|guardian1_email|value|g uardian1_workplace|value|guardian2_staddress|value |guardian2_city|value|guardian2_
state|value|guardian2_zipcode|value|guardian2_home |value|guardian2_work|value|guardian2_cell|value|g uardian2_email|value|guardian2_w
orkplace|value|child1_first|value|child1_last|valu e|child1_age|value|child1_dob|value|child2_first|v alue|child2_last|value|child2_ag
e|value|child2_dob|value|child1_allergies|value|ch ild2_allergies|value|child1_bus|value|child1_photo |value|child2_bus|value|child2_p
hoto|value|child3_first|value|child3_last|value|ch ild3_age|value|child3_dob|value|child4_first|value |child4_last|value|child4_age|va
lue|child4_dob|value|child3_allergies|value|child4 _allergies|value|child3_bus|value|child3_photo|val ue|child4_bus|value|child4_photo
|value|child5_first|value|child5_last|value|child5 _age|value|child5_dob|value|child6_first|value|chi ld6_last|value|child6_age|value|
child6_dob|value|child5_allergies|value|child6_all ergies|value|child5_bus|value|child5_photo|value|c hild6_bus|value|child6_photo|val
ue|child7_first|value|child7_last|value|child7_age |value|child7_dob|value|child8_first|value|child8_ last|value|child8_age|value|chil
d8_dob|value|child7_allergies|value|child8_allergi es|value|child7_bus|value|child7_photo|value|child 8_bus|value|child8_photo|value|c
hild9_first|value|child9_last|value|child9_age|val ue|child9_dob|value|child10_first|value|child10_la st|value|child10_age|value|child
10_dob|value|child9_allergies|value|child10_allerg ies|value|child9_bus|value|child9_photo|value|chil d10_bus|value|child10_photo|valu
e|canpickup1_first|value|canpickup1_last|value|can pickup1_license|value|canpickup1_relationship|valu e|canpickup2_first|value|canpick
up2_last|value|canpickup2_license|value|canpickup2 _relationship|value|canpickup3_first|value|canpick up3_last|value|canpickup3_licens
e|value|canpickup3_relationship|value|canpickup4_f irst|value|canpickup4_last|value|canpickup4_licens e|value|canpickup4_relationship|
value|canpickup5_first|value|canpickup5_last|value |canpickup5_license|value|canpickup5_relationship| value|canpickup6_first|value|can
pickup6_last|value|canpickup6_license|value|canpic kup6_relationship|value|canpickup7_first|value|can pickup7_last|value|canpickup7_li
cense|value|canpickup7_relationship|value|canpicku p8_first|value|canpickup8_last|value|canpickup8_li cense|value|canpickup8_relations
hip|value|canpickup9_first|value|canpickup9_last|v alue|canpickup9_license|value|canpickup9_relations hip|value|canpickup10_first|valu
e|canpickup10_last|value|canpickup10_license|value |canpickup10_relationship|value"
MM_columnsStr =
"guardian1_first|',none,''|guardian1_last|',none,' '|guardian1_license|',none,''|guardian2_first|',no ne,''|guardian2_last|',none,''|g
uardian2_license|',none,''|guardian1_staddress|',n one,''|guardian1_city|',none,''|guardian1_state|', none,''|guardian1_zipcode|',none
,''|guardian1_home|',none,''|guardian1_work|',none ,''|guardian1_cell|',none,''|guardian1_email|',non e,''|guardian1_workplace|',none,
''|guardian2_staddress|',none,''|guardian2_city|', none,''|guardian2_state|',none,''|guardian2_zipcod e|',none,''|guardian2_home|',non
e,''|guardian2_work|',none,''|guardian2_cell|',non e,''|guardian2_email|',none,''|guardian2_workplace |',none,''|child1_first|',none,'
'|child1_last|',none,''|child1_age|',none,''|child 1_dob|',none,NULL|child2_first|',none,''|child2_la st|',none,''|child2_age|',none,'
'|child2_dob|',none,NULL|child1_allergies|',none,' '|child2_allergies|',none,''|child1_bus|',none,''| child1_photo|',none,''|child2_bu
s|',none,''|child2_photo|',none,''|child3_first|', none,''|child3_last|',none,''|child3_age|',none,'' |child3_dob|',none,NULL|child4_f
irst|',none,''|child4_last|',none,''|child4_age|', none,''|child4_dob|',none,NULL|child3_allergies|', none,''|child4_allergies|',none,
''|child3_bus|',none,''|child3_photo|',none,''|chi ld4_bus|',none,''|child4_photo|',none,''|child5_fi rst|',none,''|child5_last|',none
,''|child5_age|',none,''|child5_dob|',none,NULL|ch ild6_first|',none,''|child6_last|',none,''|child6_ age|',none,''|child6_dob|',none,
NULL|child5_allergies|',none,''|child6_allergies|' ,none,''|child5_bus|',none,''|child5_photo|',none, ''|child6_bus|',none,''|child6_p
hoto|',none,''|child7_first|',none,''|child7_last| ',none,''|child7_age|',none,''|child7_dob|',none,N ULL|child8_first|',none,''|child
8_last|',none,''|child8_age|',none,''|child8_dob|' ,none,NULL|child7_allergies|',none,''|child8_aller gies|',none,''|child7_bus|',none
,''|child7_photo|',none,''|child8_bus|',none,''|ch ild8_photo|',none,''|child9_first|',none,''|child9 _last|',none,''|child9_age|',non
e,''|child9_dob|',none,NULL|child10_first|',none,' '|child10_last|',none,''|child10_age|',none,''|chi ld10_dob|',none,NULL|child9_alle
rgies|',none,''|child10_allergies|',none,''|child9 _bus|',none,''|child9_photo|',none,''|child10_bus| ',none,''|child10_photo|',none,'
'|canpickup1_first|',none,''|canpickup1_last|',non e,''|canpickup1_license|',none,''|canpickup1_relat ionship|',none,''|canpickup2_fir
st|',none,''|canpickup2_last|',none,''|canpickup2_ license|',none,''|canpickup2_relationship|',none,' '|canpickup3_first|',none,''|can
pickup3_last|',none,''|canpickup3_license|',none,' '|canpickup3_relationship|',none,''|canpickup4_fir st|',none,''|canpickup4_last|',n
one,''|canpickup4_license|',none,''|canpickup4_rel ationship|',none,''|canpickup5_first|',none,''|can pickup5_last|',none,''|canpickup
5_license|',none,''|canpickup5_relationship|',none ,''|canpickup6_first|',none,''|canpickup6_last|',n one,''|canpickup6_license|',none
,''|canpickup6_relationship|',none,''|canpickup7_f irst|',none,''|canpickup7_last|',none,''|canpickup 7_license|',none,''|canpickup7_r
elationship|',none,''|canpickup8_first|',none,''|c anpickup8_last|',none,''|canpickup8_license|',none ,''|canpickup8_relationship|',no
ne,''|canpickup9_first|',none,''|canpickup9_last|' ,none,''|canpickup9_license|',none,''|canpickup9_r elationship|',none,''|canpickup1
0_first|',none,''|canpickup10_last|',none,''|canpi ckup10_license|',none,''|canpickup10_relationship| ',none,''"

In what context are you using this?

The code you show is setting the value of a variable, it appears, not
updating fields.

Thanks for clarifying.

Larry Linson
Microsoft Access MVP

<jjrmy1@earthlink.net> wrote in message
news:DTztc.14208$be.9980@newsread2.news.pas.earthl ink.net...[color=blue]
> does anyone know what is the maximum number of fields that can be updated[/color]
at[color=blue]
> once in access 2000
> i am updating approx. 150 at once and keep getting this error:
> Microsoft JET Database Engine error '80004005'
> Too many fields defined.
>
> i've seen this error number many times before but never with the "too many
> fields defined" in it
> here's some code:
> MM_fieldsStr =
>[/color]
"guardian1_first|value|guardian1_last|value|guardi an1_license|value|guardian
2_first|value|guardian2_last|value|guardian2_licen se|val[color=blue]
>[/color]
ue|guardian1_staddress|value|guardian1_city|value| guardian1_state|value|guar
dian1_zipcode|value|guardian1_home|value|guardian1 _work|[color=blue]
>[/color]
value|guardian1_cell|value|guardian1_email|value|g uardian1_workplace|value|g
uardian2_staddress|value|guardian2_city|value|guar dian2_[color=blue]
>[/color]
state|value|guardian2_zipcode|value|guardian2_home |value|guardian2_work|valu
e|guardian2_cell|value|guardian2_email|value|guard ian2_w[color=blue]
>[/color]
orkplace|value|child1_first|value|child1_last|valu e|child1_age|value|child1_
dob|value|child2_first|value|child2_last|value|chi ld2_ag[color=blue]
>[/color]
e|value|child2_dob|value|child1_allergies|value|ch ild2_allergies|value|child
1_bus|value|child1_photo|value|child2_bus|value|ch ild2_p[color=blue]
>[/color]
hoto|value|child3_first|value|child3_last|value|ch ild3_age|value|child3_dob|
value|child4_first|value|child4_last|value|child4_ age|va[color=blue]
>[/color]
lue|child4_dob|value|child3_allergies|value|child4 _allergies|value|child3_bu
s|value|child3_photo|value|child4_bus|value|child4 _photo[color=blue]
>[/color]
|value|child5_first|value|child5_last|value|child5 _age|value|child5_dob|valu
e|child6_first|value|child6_last|value|child6_age| value|[color=blue]
>[/color]
child6_dob|value|child5_allergies|value|child6_all ergies|value|child5_bus|va
lue|child5_photo|value|child6_bus|value|child6_pho to|val[color=blue]
>[/color]
ue|child7_first|value|child7_last|value|child7_age |value|child7_dob|value|ch
ild8_first|value|child8_last|value|child8_age|valu e|chil[color=blue]
>[/color]
d8_dob|value|child7_allergies|value|child8_allergi es|value|child7_bus|value|
child7_photo|value|child8_bus|value|child8_photo|v alue|c[color=blue]
>[/color]
hild9_first|value|child9_last|value|child9_age|val ue|child9_dob|value|child1
0_first|value|child10_last|value|child10_age|value |child[color=blue]
>[/color]
10_dob|value|child9_allergies|value|child10_allerg ies|value|child9_bus|value
|child9_photo|value|child10_bus|value|child10_phot o|valu[color=blue]
>[/color]
e|canpickup1_first|value|canpickup1_last|value|can pickup1_license|value|canp
ickup1_relationship|value|canpickup2_first|value|c anpick[color=blue]
>[/color]
up2_last|value|canpickup2_license|value|canpickup2 _relationship|value|canpic
kup3_first|value|canpickup3_last|value|canpickup3_ licens[color=blue]
>[/color]
e|value|canpickup3_relationship|value|canpickup4_f irst|value|canpickup4_last
|value|canpickup4_license|value|canpickup4_relatio nship|[color=blue]
>[/color]
value|canpickup5_first|value|canpickup5_last|value |canpickup5_license|value|
canpickup5_relationship|value|canpickup6_first|val ue|can[color=blue]
>[/color]
pickup6_last|value|canpickup6_license|value|canpic kup6_relationship|value|ca
npickup7_first|value|canpickup7_last|value|canpick up7_li[color=blue]
>[/color]
cense|value|canpickup7_relationship|value|canpicku p8_first|value|canpickup8_
last|value|canpickup8_license|value|canpickup8_rel ations[color=blue]
>[/color]
hip|value|canpickup9_first|value|canpickup9_last|v alue|canpickup9_license|va
lue|canpickup9_relationship|value|canpickup10_firs t|valu[color=blue]
>[/color]
e|canpickup10_last|value|canpickup10_license|value |canpickup10_relationship|
value"[color=blue]
> MM_columnsStr =
>[/color]
"guardian1_first|',none,''|guardian1_last|',none,' '|guardian1_license|',none
,''|guardian2_first|',none,''|guardian2_last|',non e,''|g[color=blue]
>[/color]
uardian2_license|',none,''|guardian1_staddress|',n one,''|guardian1_city|',no
ne,''|guardian1_state|',none,''|guardian1_zipcode| ',none[color=blue]
>[/color]
,''|guardian1_home|',none,''|guardian1_work|',none ,''|guardian1_cell|',none,
''|guardian1_email|',none,''|guardian1_workplace|' ,none,[color=blue]
>[/color]
''|guardian2_staddress|',none,''|guardian2_city|', none,''|guardian2_state|',
none,''|guardian2_zipcode|',none,''|guardian2_home |',non[color=blue]
>[/color]
e,''|guardian2_work|',none,''|guardian2_cell|',non e,''|guardian2_email|',non
e,''|guardian2_workplace|',none,''|child1_first|', none,'[color=blue]
>[/color]
'|child1_last|',none,''|child1_age|',none,''|child 1_dob|',none,NULL|child2_f
irst|',none,''|child2_last|',none,''|child2_age|', none,'[color=blue]
>[/color]
'|child2_dob|',none,NULL|child1_allergies|',none,' '|child2_allergies|',none,
''|child1_bus|',none,''|child1_photo|',none,''|chi ld2_bu[color=blue]
>[/color]
s|',none,''|child2_photo|',none,''|child3_first|', none,''|child3_last|',none
,''|child3_age|',none,''|child3_dob|',none,NULL|ch ild4_f[color=blue]
>[/color]
irst|',none,''|child4_last|',none,''|child4_age|', none,''|child4_dob|',none,
NULL|child3_allergies|',none,''|child4_allergies|' ,none,[color=blue]
>[/color]
''|child3_bus|',none,''|child3_photo|',none,''|chi ld4_bus|',none,''|child4_p
hoto|',none,''|child5_first|',none,''|child5_last| ',none[color=blue]
>[/color]
,''|child5_age|',none,''|child5_dob|',none,NULL|ch ild6_first|',none,''|child
6_last|',none,''|child6_age|',none,''|child6_dob|' ,none,[color=blue]
>[/color]
NULL|child5_allergies|',none,''|child6_allergies|' ,none,''|child5_bus|',none
,''|child5_photo|',none,''|child6_bus|',none,''|ch ild6_p[color=blue]
>[/color]
hoto|',none,''|child7_first|',none,''|child7_last| ',none,''|child7_age|',non
e,''|child7_dob|',none,NULL|child8_first|',none,'' |child[color=blue]
>[/color]
8_last|',none,''|child8_age|',none,''|child8_dob|' ,none,NULL|child7_allergie
s|',none,''|child8_allergies|',none,''|child7_bus| ',none[color=blue]
>[/color]
,''|child7_photo|',none,''|child8_bus|',none,''|ch ild8_photo|',none,''|child
9_first|',none,''|child9_last|',none,''|child9_age |',non[color=blue]
>[/color]
e,''|child9_dob|',none,NULL|child10_first|',none,' '|child10_last|',none,''|c
hild10_age|',none,''|child10_dob|',none,NULL|child 9_alle[color=blue]
>[/color]
rgies|',none,''|child10_allergies|',none,''|child9 _bus|',none,''|child9_phot
o|',none,''|child10_bus|',none,''|child10_photo|', none,'[color=blue]
>[/color]
'|canpickup1_first|',none,''|canpickup1_last|',non e,''|canpickup1_license|',
none,''|canpickup1_relationship|',none,''|canpicku p2_fir[color=blue]
>[/color]
st|',none,''|canpickup2_last|',none,''|canpickup2_ license|',none,''|canpicku
p2_relationship|',none,''|canpickup3_first|',none, ''|can[color=blue]
>[/color]
pickup3_last|',none,''|canpickup3_license|',none,' '|canpickup3_relationship|
',none,''|canpickup4_first|',none,''|canpickup4_la st|',n[color=blue]
>[/color]
one,''|canpickup4_license|',none,''|canpickup4_rel ationship|',none,''|canpic
kup5_first|',none,''|canpickup5_last|',none,''|can pickup[color=blue]
>[/color]
5_license|',none,''|canpickup5_relationship|',none ,''|canpickup6_first|',non
e,''|canpickup6_last|',none,''|canpickup6_license| ',none[color=blue]
>[/color]
,''|canpickup6_relationship|',none,''|canpickup7_f irst|',none,''|canpickup7_
last|',none,''|canpickup7_license|',none,''|canpic kup7_r[color=blue]
>[/color]
elationship|',none,''|canpickup8_first|',none,''|c anpickup8_last|',none,''|c
anpickup8_license|',none,''|canpickup8_relationshi p|',no[color=blue]
>[/color]
ne,''|canpickup9_first|',none,''|canpickup9_last|' ,none,''|canpickup9_licens
e|',none,''|canpickup9_relationship|',none,''|canp ickup1[color=blue]
>[/color]
0_first|',none,''|canpickup10_last|',none,''|canpi ckup10_license|',none,''|c
anpickup10_relationship|',none,''"[color=blue]
>
>
>[/color]

<jjrmy1@earthlink.net> wrote:
[color=blue]
>does anyone know what is the maximum number of fields that can be updated at
>once in access 2000
>i am updating approx. 150 at once and keep getting this error:
>Microsoft JET Database Engine error '80004005'[/color]

This table should be normalized and split into likely four or more tables.

What happens when you have a family with 11 children?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm