"Record too large" - alternatives?

  • Thread starter Thread starter RBM
  • Start date Start date
R

RBM

I have a form that displays a LOT of fields (close to the
250 limit). Most of these fields are text fields that are
used to show names and companies. These can run up to 20-
25 characters each. Needless to say, I eat up the 2000
characters per record limit in Access97 fast.

I have tried using memo fields instead of text fields to
try to get around the 2000 limit and have had mixed
success. Also, other than not being able to index/sort
memo fields, I may be missing other traps.

Does anyone have any other imaginative ways to get lots of
fields with text into a record/form?

Ingenuity and creativity - makes life exciting!
 
From what you say, it appears that your tables are not normalized.

Normalization is a bit of database jargon, so if you dont know what that is,
a. Feel free to ask for more info or do a google search, and
b. Your tables are probably not normalized
So, first, consider normalizing your tables.

If your tables are already normalized, and you still have a need for wider
tables then you can create a second table
with the extra fields and link the two tables in a 1 to 1 relationship using
the key field(s).

HS
 
Sure!
you can create a query and use that as the recordsource for the form.
In some cases, the recordsource may not be updateable, but that is a
different question.
 
Use a query for the record source.
-----Original Message-----

I think this relates to my question of yesterday. So is
it possible to specify a record source for a form as
multiple linked tables? How? Thanks.
dont
know what that is, have
a need for wider 1
relationship using lots
.
Click to expand...
 
Thanks for the imput. I probably could do more to
normalize the tables I have, but I believe my problem is
simply that I am trying to get too much data from a single
table into a form. I tried working around the 2000
character limit by using memo fields instead of text
fields where I could - this didn't solve the problem, it
just gave me a little more room.

I now plan to approach it by using multiple, smaller,
normalized table, joind by a query which will be the
source for the form. Thanks again.
 
Back
Top