Record is too large Microsoft Access

[quannb]

im very bad at english. i hope u can understand my mind.

i have a query string belong when i click run button in ms access then messagebox show "Record is too large"
can u so me where is wrong query
thanks alot

create table DM_REPORT(REPORT_ID char(50),PARENT_ID char(50),REPORT_GROUP_ID char(50),REPORT_NAME memo,LIST_ORDER int,TEMPLATE_ID char(50),TEMPLATE_TABLE char(50),TEMPLATE_TABLE_TMP char(50),REPORT_FILE_NAME char(100),NUM_FILE_REPORT int,PAPER_SIZE char(15),PAGE_ORIENT char(15),PAGE_MARGIN_TOP int,PAGE_MARGIN_BOTTOM int,PAGE_MARGIN_LEFT int,PAGE_MARGIN_RIGHT int,REQUIRED_FILTER memo,REQUIRED_FILTER_DISTINCT memo,FILTER_LIST memo,SUBTITLE1 char(30),SUBTITLE2 char(30),SUBTITLE3 char(30),SUBTITLE4 char(30),SUBTITLE5 char(30),GROUP_FIELD1 char(30),GROUP_FIELD2 char(30),GROUP_FIELD3 char(30),GROUP_FIELD4 char(30),GROUP_FIELD5 char(30),GROUP_TABLE1 char(30),GROUP_TABLE2 char(30),GROUP_TABLE3 char(30),GROUP_TABLE4 char(30),GROUP_TABLE5 char(30),SORT_FIELD1 char(30),SORT_FIELD2 char(30),SORT_FIELD3 char(30),SORT_FIELD4 char(30),SORT_FIELD5 char(30),SORT_DIRECTION1 char(4),SORT_DIRECTION2 char(4),SORT_DIRECTION3 char(4),SORT_DIRECTION4 char(4),SORT_DIRECTION5 char(4),FOOTER1 char(50),FOOTER2 char(50),FOOTER3 char(50),CONFIG smallint,CONFIG_VAL1 char(50),CONFIG_VAL2 char(50),CONFIG_VAL3 char(50),CONFIG_VAL4 char(50),CONFIG_VAL5 char(50),CONFIG_VAL6 char(50),CONFIG_VAL7 char(50),CONFIG_VAL8 char(50),CONFIG_VAL9 char(50),CONFIG_VAL10 char(50),CONFIG_VAL11 char(50),CONFIG_VAL12 char(50),CONFIG_VAL13 char(50),CONFIG_VAL14 char(50),CONFIG_VAL15 char(50),CONFIG_VAL16 char(50),CONFIG_VAL17 char(50),CONFIG_VAL18 char(50),CONFIG_VAL19 char(50),CONFIG_VAL20 char(50),TITLE_FONT_NAME char(30),TITLE_FONT_STYLE char(30),TITLE_FONT_SIZE int,TITLE_FONT_COLOR char(20),SUBTITLE_FONT_NAME char(30),SUBTITLE_FONT_STYLE char(30),SUBTITLE_FONT_SIZE int,SUBTITLE_FONT_COLOR char(20),HEADER_FONT_NAME char(30),HEADER_FONT_STYLE char(30),HEADER_FONT_SIZE int,HEADER_FONT_COLOR char(20),FOOTER_FONT_NAME char(30),FOOTER_FONT_STYLE char(30),FOOTER_FONT_SIZE int,FOOTER_FONT_COLOR char(20),GROUP_FONT_NAME char(30),GROUP_FONT_STYLE char(30),GROUP_FONT_SIZE int,GROUP_FONT_COLOR char(20),DETAIL_FONT_NAME char(30),DETAIL_FONT_STYLE char(30),DETAIL_FONT_SIZE int,DETAIL_FONT_COLOR char(20),MODULE_ID char(15),FORMULA smallint,ACTIVE smallint,PRINT_CONDITION memo,PRINT_STYLE char(10),SHOW_ORDER smallint,TK_NKBK smallint,COPY smallint,DATA_SOURCE char(2),LOAI_TTE char(10),CUSTOM_REPORT_FILE smallint,REPORT_LANGUAGE char(2),SHOW_BALANCE smallint,TONG_HOP smallint,CONFIG_VAL_NAME1 char(50),CONFIG_VAL_NAME2 char(50),CONFIG_VAL_NAME3 char(50),CONFIG_VAL_NAME4 char(50),CONFIG_VAL_NAME5 char(50),CONFIG_VAL_NAME6 char(50),CONFIG_VAL_NAME7 char(50),CONFIG_VAL_NAME8 char(50),CONFIG_VAL_NAME9 char(50),CONFIG_VAL_NAME10 char(50),SHOW_LKE smallint,REPEAT_COLUMN smallint,SHOW_BALANCE_NTE smallint,SHOW_LKE_NTE smallint,FOOTER4 char(50),FOOTER_NAME1 char(50),FOOTER_NAME2 char(50),FOOTER_NAME3 char(50),FOOTER_NAME4 char(50),DETAIL_HEIGHT int,SHOW_TEXT char(20))

[Rabbit]

Your table is way too large. You should normalize your structure and break up the table.