By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,063 Members | 1,269 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,063 IT Pros & Developers. It's quick & easy.

max fields

P: n/a
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,''"

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

<jj****@earthlink.net> wrote in message
news:DT*****************@newsread2.news.pas.earthl ink.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|guardi an1_license|value|guardian
2_first|value|guardian2_last|value|guardian2_licen se|val ue|guardian1_staddress|value|guardian1_city|value| guardian1_state|value|guar
dian1_zipcode|value|guardian1_home|value|guardian1 _work| value|guardian1_cell|value|guardian1_email|value|g uardian1_workplace|value|g
uardian2_staddress|value|guardian2_city|value|guar dian2_ state|value|guardian2_zipcode|value|guardian2_home |value|guardian2_work|valu
e|guardian2_cell|value|guardian2_email|value|guard ian2_w orkplace|value|child1_first|value|child1_last|valu e|child1_age|value|child1_
dob|value|child2_first|value|child2_last|value|chi ld2_ag 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 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_bu
s|value|child3_photo|value|child4_bus|value|child4 _photo |value|child5_first|value|child5_last|value|child5 _age|value|child5_dob|valu
e|child6_first|value|child6_last|value|child6_age| value| child6_dob|value|child5_allergies|value|child6_all ergies|value|child5_bus|va
lue|child5_photo|value|child6_bus|value|child6_pho to|val 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 d8_dob|value|child7_allergies|value|child8_allergi es|value|child7_bus|value|
child7_photo|value|child8_bus|value|child8_photo|v alue|c hild9_first|value|child9_last|value|child9_age|val ue|child9_dob|value|child1
0_first|value|child10_last|value|child10_age|value |child 10_dob|value|child9_allergies|value|child10_allerg ies|value|child9_bus|value
|child9_photo|value|child10_bus|value|child10_phot o|valu e|canpickup1_first|value|canpickup1_last|value|can pickup1_license|value|canp
ickup1_relationship|value|canpickup2_first|value|c anpick up2_last|value|canpickup2_license|value|canpickup2 _relationship|value|canpic
kup3_first|value|canpickup3_last|value|canpickup3_ licens e|value|canpickup3_relationship|value|canpickup4_f irst|value|canpickup4_last
|value|canpickup4_license|value|canpickup4_relatio nship| value|canpickup5_first|value|canpickup5_last|value |canpickup5_license|value|
canpickup5_relationship|value|canpickup6_first|val ue|can pickup6_last|value|canpickup6_license|value|canpic kup6_relationship|value|ca
npickup7_first|value|canpickup7_last|value|canpick up7_li cense|value|canpickup7_relationship|value|canpicku p8_first|value|canpickup8_
last|value|canpickup8_license|value|canpickup8_rel ations hip|value|canpickup9_first|value|canpickup9_last|v alue|canpickup9_license|va
lue|canpickup9_relationship|value|canpickup10_firs t|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|',non e,''|g uardian2_license|',none,''|guardian1_staddress|',n one,''|guardian1_city|',no
ne,''|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|',non e,''|guardian2_email|',non
e,''|guardian2_workplace|',none,''|child1_first|', none,' '|child1_last|',none,''|child1_age|',none,''|child 1_dob|',none,NULL|child2_f
irst|',none,''|child2_last|',none,''|child2_age|', none,' '|child2_dob|',none,NULL|child1_allergies|',none,' '|child2_allergies|',none,
''|child1_bus|',none,''|child1_photo|',none,''|chi ld2_bu s|',none,''|child2_photo|',none,''|child3_first|', none,''|child3_last|',none
,''|child3_age|',none,''|child3_dob|',none,NULL|ch ild4_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_p
hoto|',none,''|child5_first|',none,''|child5_last| ',none ,''|child5_age|',none,''|child5_dob|',none,NULL|ch ild6_first|',none,''|child
6_last|',none,''|child6_age|',none,''|child6_dob|' ,none, NULL|child5_allergies|',none,''|child6_allergies|' ,none,''|child5_bus|',none
,''|child5_photo|',none,''|child6_bus|',none,''|ch ild6_p hoto|',none,''|child7_first|',none,''|child7_last| ',none,''|child7_age|',non
e,''|child7_dob|',none,NULL|child8_first|',none,'' |child 8_last|',none,''|child8_age|',none,''|child8_dob|' ,none,NULL|child7_allergie
s|',none,''|child8_allergies|',none,''|child7_bus| ',none ,''|child7_photo|',none,''|child8_bus|',none,''|ch ild8_photo|',none,''|child
9_first|',none,''|child9_last|',none,''|child9_age |',non e,''|child9_dob|',none,NULL|child10_first|',none,' '|child10_last|',none,''|c
hild10_age|',none,''|child10_dob|',none,NULL|child 9_alle rgies|',none,''|child10_allergies|',none,''|child9 _bus|',none,''|child9_phot
o|',none,''|child10_bus|',none,''|child10_photo|', none,' '|canpickup1_first|',none,''|canpickup1_last|',non e,''|canpickup1_license|',
none,''|canpickup1_relationship|',none,''|canpicku p2_fir st|',none,''|canpickup2_last|',none,''|canpickup2_ license|',none,''|canpicku
p2_relationship|',none,''|canpickup3_first|',none, ''|can pickup3_last|',none,''|canpickup3_license|',none,' '|canpickup3_relationship|
',none,''|canpickup4_first|',none,''|canpickup4_la st|',n one,''|canpickup4_license|',none,''|canpickup4_rel ationship|',none,''|canpic
kup5_first|',none,''|canpickup5_last|',none,''|can pickup 5_license|',none,''|canpickup5_relationship|',none ,''|canpickup6_first|',non
e,''|canpickup6_last|',none,''|canpickup6_license| ',none ,''|canpickup6_relationship|',none,''|canpickup7_f irst|',none,''|canpickup7_
last|',none,''|canpickup7_license|',none,''|canpic kup7_r elationship|',none,''|canpickup8_first|',none,''|c anpickup8_last|',none,''|c
anpickup8_license|',none,''|canpickup8_relationshi p|',no ne,''|canpickup9_first|',none,''|canpickup9_last|' ,none,''|canpickup9_licens
e|',none,''|canpickup9_relationship|',none,''|canp ickup1 0_first|',none,''|canpickup10_last|',none,''|canpi ckup10_license|',none,''|c
anpickup10_relationship|',none,''"

Nov 13 '05 #2

P: n/a
<jj****@earthlink.net> wrote:
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'


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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.