|
|
|
#of fields |
|---|
| message from jjrmy1 on 28 May 2004 |
does anyone know what is the maximum number of fields that can be updated at
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,''"
|
| Douglas J. Steele replied to jjrmy1 on 28 May 2004 |
No offense, but it looks as though your table is in dire need of
normalization. If you do that, you won't have that many fields to update in
a single statement.
|
| Tom Wickerath replied to jjrmy1 on 27 May 2004 |
Perhaps this KB article applies in your situation?
http://support.microsoft.com/?id=199076
Tom
___________________________________________
<jjrmy1@earthlink.net> wrote in message
news:8Uztc.14210$be.12864@newsread2.news.pas.earthlink.net...
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|guardia
n2_last|value|guardian2_license|val
ue|guardian1_staddress|value|guardian1_city|value|guardian1_state|value|guardian1_zipcode|value|g
uardian1_home|value|guardian1_work|
value|guardian1_cell|value|guardian1_email|value|guardian1_workplace|value|guardian2_staddress|va
lue|guardian2_city|value|guardian2_
state|value|guardian2_zipcode|value|guardian2_home|value|guardian2_work|value|guardian2_cell|valu
e|guardian2_email|value|guardian2_w
orkplace|value|child1_first|value|child1_last|value|child1_age|value|child1_dob|value|child2_firs
t|value|child2_last|value|child2_ag
e|value|child2_dob|value|child1_allergies|value|child2_allergies|value|child1_bus|value|child1_ph
oto|value|child2_bus|value|child2_p
hoto|value|child3_first|value|child3_last|value|child3_age|value|child3_dob|value|child4_first|va
lue|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|valu
e|child6_bus|value|child6_photo|val
ue|child7_first|value|child7_last|value|child7_age|value|child7_dob|value|child8_first|value|chil
d8_last|value|child8_age|value|chil
d8_dob|value|child7_allergies|value|child8_allergies|value|child7_bus|value|child7_photo|value|ch
ild8_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|c
hild10_bus|value|child10_photo|valu
e|canpickup1_first|value|canpickup1_last|value|canpickup1_license|value|canpickup1_relationship|v
alue|canpickup2_first|value|canpick
up2_last|value|canpickup2_license|value|canpickup2_relationship|value|canpickup3_first|value|canp
ickup3_last|value|canpickup3_licens
e|value|canpickup3_relationship|value|canpickup4_first|value|canpickup4_last|value|canpickup4_lic
ense|value|canpickup4_relationship|
value|canpickup5_first|value|canpickup5_last|value|canpickup5_license|value|canpickup5_relationsh
ip|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_relati
onship|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_zip
code|',none,''|guardian2_home|',non
e,''|guardian2_work|',none,''|guardian2_cell|',none,''|guardian2_email|',none,''|guardian2_workpl
ace|',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,''|chil
d6_age|',none,''|child6_dob|',none,
NULL|child5_allergies|',none,''|child6_allergies|',none,''|child5_bus|',none,''|child5_photo|',no
ne,''|child6_bus|',none,''|child6_p
hoto|',none,''|child7_first|',none,''|child7_last|',none,''|child7_age|',none,''|child7_dob|',non
e,NULL|child8_first|',none,''|child
8_last|',none,''|child8_age|',none,''|child8_dob|',none,NULL|child7_allergies|',none,''|child8_al
lergies|',none,''|child7_bus|',none
,''|child7_photo|',none,''|child8_bus|',none,''|child8_photo|',none,''|child9_first|',none,''|chi
ld9_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_b
us|',none,''|child10_photo|',none,'
'|canpickup1_first|',none,''|canpickup1_last|',none,''|canpickup1_license|',none,''|canpickup1_re
lationship|',none,''|canpickup2_fir
st|',none,''|canpickup2_last|',none,''|canpickup2_license|',none,''|canpickup2_relationship|',non
e,''|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,''|canpic
kup7_license|',none,''|canpickup7_r
elationship|',none,''|canpickup8_first|',none,''|canpickup8_last|',none,''|canpickup8_license|',n
one,''|canpickup8_relationship|',no
ne,''|canpickup9_first|',none,''|canpickup9_last|',none,''|canpickup9_license|',none,''|canpickup
9_relationship|',none,''|canpickup1
0_first|',none,''|canpickup10_last|',none,''|canpickup10_license|',none,''|canpickup10_relationsh
ip|',none,''"
|
| jjrmy1 replied to Tom Wickerath on 28 May 2004 |
awwwww crap! Thanks a bunch man!
|
|
