G
Guest
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|guardian1_license|value|guardian2_first|value|guardian2_last|value|guardian2_license|val
ue|guardian1_staddress|value|guardian1_city|value|guardian1_state|value|guardian1_zipcode|value|guardian1_home|value|guardian1_work|
value|guardian1_cell|value|guardian1_email|value|guardian1_workplace|value|guardian2_staddress|value|guardian2_city|value|guardian2_
state|value|guardian2_zipcode|value|guardian2_home|value|guardian2_work|value|guardian2_cell|value|guardian2_email|value|guardian2_w
orkplace|value|child1_first|value|child1_last|value|child1_age|value|child1_dob|value|child2_first|value|child2_last|value|child2_ag
e|value|child2_dob|value|child1_allergies|value|child2_allergies|value|child1_bus|value|child1_photo|value|child2_bus|value|child2_p
hoto|value|child3_first|value|child3_last|value|child3_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|value|child4_bus|value|child4_photo
|value|child5_first|value|child5_last|value|child5_age|value|child5_dob|value|child6_first|value|child6_last|value|child6_age|value|
child6_dob|value|child5_allergies|value|child6_allergies|value|child5_bus|value|child5_photo|value|child6_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_allergies|value|child7_bus|value|child7_photo|value|child8_bus|value|child8_photo|value|c
hild9_first|value|child9_last|value|child9_age|value|child9_dob|value|child10_first|value|child10_last|value|child10_age|value|child
10_dob|value|child9_allergies|value|child10_allergies|value|child9_bus|value|child9_photo|value|child10_bus|value|child10_photo|valu
e|canpickup1_first|value|canpickup1_last|value|canpickup1_license|value|canpickup1_relationship|value|canpickup2_first|value|canpick
up2_last|value|canpickup2_license|value|canpickup2_relationship|value|canpickup3_first|value|canpickup3_last|value|canpickup3_licens
e|value|canpickup3_relationship|value|canpickup4_first|value|canpickup4_last|value|canpickup4_license|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|canpickup6_relationship|value|canpickup7_first|value|canpickup7_last|value|canpickup7_li
cense|value|canpickup7_relationship|value|canpickup8_first|value|canpickup8_last|value|canpickup8_license|value|canpickup8_relations
hip|value|canpickup9_first|value|canpickup9_last|value|canpickup9_license|value|canpickup9_relationship|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|',none,''|guardian2_last|',none,''|g
uardian2_license|',none,''|guardian1_staddress|',none,''|guardian1_city|',none,''|guardian1_state|',none,''|guardian1_zipcode|',none
,''|guardian1_home|',none,''|guardian1_work|',none,''|guardian1_cell|',none,''|guardian1_email|',none,''|guardian1_workplace|',none,
''|guardian2_staddress|',none,''|guardian2_city|',none,''|guardian2_state|',none,''|guardian2_zipcode|',none,''|guardian2_home|',non
e,''|guardian2_work|',none,''|guardian2_cell|',none,''|guardian2_email|',none,''|guardian2_workplace|',none,''|child1_first|',none,'
'|child1_last|',none,''|child1_age|',none,''|child1_dob|',none,NULL|child2_first|',none,''|child2_last|',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,''|child4_bus|',none,''|child4_photo|',none,''|child5_first|',none,''|child5_last|',none
,''|child5_age|',none,''|child5_dob|',none,NULL|child6_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,NULL|child8_first|',none,''|child
8_last|',none,''|child8_age|',none,''|child8_dob|',none,NULL|child7_allergies|',none,''|child8_allergies|',none,''|child7_bus|',none
,''|child7_photo|',none,''|child8_bus|',none,''|child8_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,''|child10_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|',none,''|canpickup1_license|',none,''|canpickup1_relationship|',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_first|',none,''|canpickup4_last|',n
one,''|canpickup4_license|',none,''|canpickup4_relationship|',none,''|canpickup5_first|',none,''|canpickup5_last|',none,''|canpickup
5_license|',none,''|canpickup5_relationship|',none,''|canpickup6_first|',none,''|canpickup6_last|',none,''|canpickup6_license|',none
,''|canpickup6_relationship|',none,''|canpickup7_first|',none,''|canpickup7_last|',none,''|canpickup7_license|',none,''|canpickup7_r
elationship|',none,''|canpickup8_first|',none,''|canpickup8_last|',none,''|canpickup8_license|',none,''|canpickup8_relationship|',no
ne,''|canpickup9_first|',none,''|canpickup9_last|',none,''|canpickup9_license|',none,''|canpickup9_relationship|',none,''|canpickup1
0_first|',none,''|canpickup10_last|',none,''|canpickup10_license|',none,''|canpickup10_relationship|',none,''"
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|guardian1_license|value|guardian2_first|value|guardian2_last|value|guardian2_license|val
ue|guardian1_staddress|value|guardian1_city|value|guardian1_state|value|guardian1_zipcode|value|guardian1_home|value|guardian1_work|
value|guardian1_cell|value|guardian1_email|value|guardian1_workplace|value|guardian2_staddress|value|guardian2_city|value|guardian2_
state|value|guardian2_zipcode|value|guardian2_home|value|guardian2_work|value|guardian2_cell|value|guardian2_email|value|guardian2_w
orkplace|value|child1_first|value|child1_last|value|child1_age|value|child1_dob|value|child2_first|value|child2_last|value|child2_ag
e|value|child2_dob|value|child1_allergies|value|child2_allergies|value|child1_bus|value|child1_photo|value|child2_bus|value|child2_p
hoto|value|child3_first|value|child3_last|value|child3_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|value|child4_bus|value|child4_photo
|value|child5_first|value|child5_last|value|child5_age|value|child5_dob|value|child6_first|value|child6_last|value|child6_age|value|
child6_dob|value|child5_allergies|value|child6_allergies|value|child5_bus|value|child5_photo|value|child6_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_allergies|value|child7_bus|value|child7_photo|value|child8_bus|value|child8_photo|value|c
hild9_first|value|child9_last|value|child9_age|value|child9_dob|value|child10_first|value|child10_last|value|child10_age|value|child
10_dob|value|child9_allergies|value|child10_allergies|value|child9_bus|value|child9_photo|value|child10_bus|value|child10_photo|valu
e|canpickup1_first|value|canpickup1_last|value|canpickup1_license|value|canpickup1_relationship|value|canpickup2_first|value|canpick
up2_last|value|canpickup2_license|value|canpickup2_relationship|value|canpickup3_first|value|canpickup3_last|value|canpickup3_licens
e|value|canpickup3_relationship|value|canpickup4_first|value|canpickup4_last|value|canpickup4_license|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|canpickup6_relationship|value|canpickup7_first|value|canpickup7_last|value|canpickup7_li
cense|value|canpickup7_relationship|value|canpickup8_first|value|canpickup8_last|value|canpickup8_license|value|canpickup8_relations
hip|value|canpickup9_first|value|canpickup9_last|value|canpickup9_license|value|canpickup9_relationship|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|',none,''|guardian2_last|',none,''|g
uardian2_license|',none,''|guardian1_staddress|',none,''|guardian1_city|',none,''|guardian1_state|',none,''|guardian1_zipcode|',none
,''|guardian1_home|',none,''|guardian1_work|',none,''|guardian1_cell|',none,''|guardian1_email|',none,''|guardian1_workplace|',none,
''|guardian2_staddress|',none,''|guardian2_city|',none,''|guardian2_state|',none,''|guardian2_zipcode|',none,''|guardian2_home|',non
e,''|guardian2_work|',none,''|guardian2_cell|',none,''|guardian2_email|',none,''|guardian2_workplace|',none,''|child1_first|',none,'
'|child1_last|',none,''|child1_age|',none,''|child1_dob|',none,NULL|child2_first|',none,''|child2_last|',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,''|child4_bus|',none,''|child4_photo|',none,''|child5_first|',none,''|child5_last|',none
,''|child5_age|',none,''|child5_dob|',none,NULL|child6_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,NULL|child8_first|',none,''|child
8_last|',none,''|child8_age|',none,''|child8_dob|',none,NULL|child7_allergies|',none,''|child8_allergies|',none,''|child7_bus|',none
,''|child7_photo|',none,''|child8_bus|',none,''|child8_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,''|child10_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|',none,''|canpickup1_license|',none,''|canpickup1_relationship|',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_first|',none,''|canpickup4_last|',n
one,''|canpickup4_license|',none,''|canpickup4_relationship|',none,''|canpickup5_first|',none,''|canpickup5_last|',none,''|canpickup
5_license|',none,''|canpickup5_relationship|',none,''|canpickup6_first|',none,''|canpickup6_last|',none,''|canpickup6_license|',none
,''|canpickup6_relationship|',none,''|canpickup7_first|',none,''|canpickup7_last|',none,''|canpickup7_license|',none,''|canpickup7_r
elationship|',none,''|canpickup8_first|',none,''|canpickup8_last|',none,''|canpickup8_license|',none,''|canpickup8_relationship|',no
ne,''|canpickup9_first|',none,''|canpickup9_last|',none,''|canpickup9_license|',none,''|canpickup9_relationship|',none,''|canpickup1
0_first|',none,''|canpickup10_last|',none,''|canpickup10_license|',none,''|canpickup10_relationship|',none,''"
