Table Design Limit

T

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
 
D

Duane Hookom

Check Access Specifications in Help
"Number of characters in a record (excluding Memo and OLE Object fields)
2,000"
 
L

Larry Daugherty

Hi Taccea,

You've probably hit the 2000 character per record limit in Table A. You can
change any or all of the text type fields to memo type to overcome that
limit.

That thing you're calling Table A doesn't really belong in your database
because it contains a copy of data already in the database. Why you need a
flat file? What is the required mechanism of its generation or better; What
does the next part of the process expect?

HTH
 
Top