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
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,''"

Yipes...

It looks like you might want to restructure your database. The first that
jumps out at me is creating a children table that includes things like
allergies, bus, name, dob, etc... You might also consider creating an adult
table too that includes guardians and folks allowed to pickup kids. The way
you're doing it now, doesn't give you much flexibility when it comes to
queries and makes for a lot of empty fields and slower queries. Splitting
it up allows you to do things like:
query the number of kids per guardian
query the average number of kids per guardian
query the number of kids on a given bus
query the most common allergies
query the average age of all the kids
print a list of adults who can pickup a kid
print a phone list of all guardians
and much much more...

Best,

--
Jeremy Shapiro
Asandia, Corp.
www.asandia.com
1.866.ASANDIA (272.6342)

<jjrmy1 (AT) earthlink (DOT) net> wrote

2_first|value|guardian2_last|value|guardian2_licen se|val
dian1_zipcode|value|guardian1_home|value|guardian1 _work|
uardian2_staddress|value|guardian2_city|value|guar dian2_
e|guardian2_cell|value|guardian2_email|value|guard ian2_w
dob|value|child2_first|value|child2_last|value|chi ld2_ag
1_bus|value|child1_photo|value|child2_bus|value|ch ild2_p
value|child4_first|value|child4_last|value|child4_ age|va
s|value|child3_photo|value|child4_bus|value|child4 _photo
lue|child5_photo|value|child6_bus|value|child6_pho to|val
ild8_first|value|child8_last|value|child8_age|valu e|chil
child7_photo|value|child8_bus|value|child8_photo|v alue|c
0_first|value|child10_last|value|child10_age|value |child
ickup1_relationship|value|canpickup2_first|value|c anpick
kup3_first|value|canpickup3_last|value|canpickup3_ licens
canpickup5_relationship|value|canpickup6_first|val ue|can
npickup7_first|value|canpickup7_last|value|canpick up7_li
last|value|canpickup8_license|value|canpickup8_rel ations
lue|canpickup9_relationship|value|canpickup10_firs t|valu
value"
,''|guardian2_first|',none,''|guardian2_last|',non e,''|g
ne,''|guardian1_state|',none,''|guardian1_zipcode| ',none
''|guardian1_email|',none,''|guardian1_workplace|' ,none,
none,''|guardian2_zipcode|',none,''|guardian2_home |',non
e,''|guardian2_workplace|',none,''|child1_first|', none,'
irst|',none,''|child2_last|',none,''|child2_age|', none,'
''|child1_bus|',none,''|child1_photo|',none,''|chi ld2_bu
,''|child3_age|',none,''|child3_dob|',none,NULL|ch ild4_f
NULL|child3_allergies|',none,''|child4_allergies|' ,none,
hoto|',none,''|child5_first|',none,''|child5_last| ',none
6_last|',none,''|child6_age|',none,''|child6_dob|' ,none,
,''|child5_photo|',none,''|child6_bus|',none,''|ch ild6_p
e,''|child7_dob|',none,NULL|child8_first|',none,'' |child
s|',none,''|child8_allergies|',none,''|child7_bus| ',none
9_first|',none,''|child9_last|',none,''|child9_age |',non
hild10_age|',none,''|child10_dob|',none,NULL|child 9_alle
o|',none,''|child10_bus|',none,''|child10_photo|', none,'
none,''|canpickup1_relationship|',none,''|canpicku p2_fir
p2_relationship|',none,''|canpickup3_first|',none, ''|can
',none,''|canpickup4_first|',none,''|canpickup4_la st|',n
kup5_first|',none,''|canpickup5_last|',none,''|can pickup
e,''|canpickup6_last|',none,''|canpickup6_license| ',none
last|',none,''|canpickup7_license|',none,''|canpic kup7_r
anpickup8_license|',none,''|canpickup8_relationshi p|',no
e|',none,''|canpickup9_relationship|',none,''|canp ickup1
anpickup10_relationship|',none,''"