Table Design Limit

[taccea]

Hello comrads,
I am in need of some help.

Access2K.
I have table A and B.
Table A has 48 fields, all textual, 1 field has invoice#
and other 47 are text fields of 255 width each.

Table B has 2 fields, invoice# and line items with char width also of 255.

I want to create flat file on table A that contains
one record per invoice. I am scrolling through table B and copying each
record into 47 fields on table A.
I get an undefined error.
I've shorten the chars on table B via variable to 81 or less and it works,
but 82 or more it fails after importing a few records. The access2K docs do
not show I am over any limits.
Any suggestions appreciated !!

Taccea

 

[Van T. Dinh]

There is a limit of Record length. In A97, it is 2K characters in total. I
am not sure about 2K0 or 2K2 (the Unicode confuses me) but it sounds like
you have hit the limit.

Note that Text Fields are included in the above limit but Memo Fields are
not. Perhaps, you can convert some of the Text Fields to Memo Fields.

 

[taccea]

Thanks
taccea

There is a limit of Record length. In A97, it is 2K characters in total. I
am not sure about 2K0 or 2K2 (the Unicode confuses me) but it sounds like
you have hit the limit.

Note that Text Fields are included in the above limit but Memo Fields are
not. Perhaps, you can convert some of the Text Fields to Memo Fields.

--
HTH
Van T. Dinh
MVP (Access)




docs