This topic is locked

Error number -2147024882

2/29/2004 2:57:34 PM
ASPRunnerPro General questions
E
ekopelowitz author

I am receiving the following error message:

Error number -2147024882

Error description [Microsoft][ODBC Microsoft Access Driver] Too many fields defined.
This error occurs after I have succesfully added a new record to the database. When I return to edit that record the error occurs when I attempt to save the changes. However, the changes do appear in the database. Thus the problem is simply in tranferring me back to the edit screen.

admin 2/29/2004

Does it print SQL query that causes this error? You can post it here if you have it.
Also you can zip and send all files from ASPRunner output folder to support AT xlinesoft.com for investigation.

E
ekopelowitz author 3/1/2004

Thank you for the quick response. I will e-mail you the fails. The SQL error message reads as follows:
Error number -2147024882

Error description [Microsoft][ODBC Microsoft Access Driver] Too many fields defined.

URL /sites/hillel/asprunner/aspquestonnaire_design/tbl_questionnaire_design_edit.asp

SQL query update [tbl_questionnaire_design] set [Questionnaire_number]=1, [Questionnaire_title]='mifgashim', [Questionnaire_Introduction]='test 3', [Questionnaire_logo2]='', [Questionnaire_print_version]='test 3', [section1title]='test 3', [section1intro]='jkl;dfjadf; jfasdjl;kfkl', [1question_1]='one more question', [1question_1type]='Checkbox', [1question_1array]='Two', [1question_2]='', [1question_2type]='', [1question_2array]='', [1question_3]='', [1question_3type]='', [1question_3array]='', [1question_4]='', [1question_4type]='', [1question_4array]='', [1question_5]='', [1question_5type]='', [1question_5array]='', [1question_6]='', [1question_6type]='', [1question_6array]='', [1question_7]='', [1question_7type]='', [1question_7array]='', [1question_8]='', [1question_8type]='', [1question_8array]='', [1question_9]='', [1question_9type]='', [1question_9array]='', [1question_10]='', [1question_10type]='', [1question_10array]='', [section2title]='', [section2intro]='', [2question_1]='', [2question_1type]='', [2question_1array]='', [2question_2]='', [2question_2type]='', [2question_2array]='', [2question_3]='', [2question_3type]='', [2question_3array]='', [2question_4]='', [2question_4type]='', [2question_4array]='', [2question_5]='', [2question_5type]='', [2question_5array]='', [2question_6]='', [2question_6type]='', [2question_6array]='', [2question_7]='', [2question_7type]='', [2question_7array]='', [2question_8]='', [2question_8type]='', [2question_8array]='', [2question_9]='', [2question_9type]='', [2question_9array]='', [2question_10]='', [2question_10type]='', [2question_10array]='', [section3title]='', [section3intro]='', [3question_1]='', [3question_1type]='', [3question_1array]='', [3question_2]='', [3question_2type]='', [3question_2array]='', [3question_3]='', [3question_3type]='', [3question_3array]='', [3question_4]='', [3question_4type]='', [3question_4array]='', [3question_5]='', [3question_5type]='', [3question_5array]='', [3question_6]='', [3question_6type]='', [3question_6array]='', [3question_7]='', [3question_7type]='', [3question_7array]='', [3question_8]='', [3question_8type]='', [3question_8array]='', [3question_9]='', [3question_9type]='', [3question_9array]='', [3question_10]='', [3question_10type]='', [3question_10array]='', [section4title]='', [section4intro]='', [4question_1]='', [4question_1type]='', [4question_1array]='', [4question_2]='', [4question_2type]='', [4question_2array]='', [4question_3]='', [4question_3type]='', [4question_3array]='', [4question_4]='', [4question_4type]='', [4question_4array]='', [4question_5]='', [4question_5type]='', [4question_5array]='', [4question_6]='', [4question_6type]='', [4question_6array]='', [4question_7]='', [4question_7type]='', [4question_7array]='', [4question_8]='', [4question_8type]='', [4question_8array]='', [4question_9]='', [4question_9type]='', [4question_9array]='', [41question_10]='', [4question_10type]='', [4question_10array]='' where [ID]=3

B
bennettsw 4/29/2004

Access keeps an internal count of total number of fields in a table and has a limit of 255 fields per table. Each time you modify a field or add a field, this count increases by 1. When you delete a field, Access does NOT reset this counter. So it's possible for you to have less than 255 fields and still get this error message.

If your field count is less than 255, just compact the database again which should reset the internal field count counter.
Also, if you are performing an UPDATE, this amount is halved - so you can only update 128 fields.