how to store text data >255

[bbxrider]

for access 2000
i have data item that can be up to 600 characters, there are about 50 other
data fields that would comprise
a complete record (row)
is there a clean way to store a larger chunk of data like this?
what i don't want to do is something like create 3 text fields, the first
would hold 1-255, then the 2nd 256-510, etc
so any logic would have to be breaking up and then re-assembling to use.
some how linking to a place to store in one piece?

 

[Luke Dalessandro]

The memo field will store text larger than 255.

I have periodic trouble with memo corruption in large, complex,
multi-user environments with Access 2000, but other people might know
more about using them successfully.

Other than that, I'm not sure what a better solution for you would be.

Luke

 

[Douglas J Steele]

Use a Memo field rather than a Text field.

 

[bbxrider]

duh, sorry for the lame post, just found the memo field, 65535 i think
should be enough

 

[(PeteCresswell)]

Per bbxrider:

so any logic would have to be breaking up and then re-assembling to use.
some how linking to a place to store in one piece?

The only thing that I can think of that might warrent the 'breaking up' approach
vs storing it all in a Memo field is the need to sort. Memo fields cannot be
sorted on. I'd also check to see if they can be searched on if that's a
requirement.

If the back end is something like SQL Server, there seems tb a 'sort of'
advantage to using Memo (VarChar...) fields: the fact that their contents seem
tb kept in separate tables by SQL Server - leaving only a pointer in the field.
This is nice if you want to keep the width of your records below some size -
like 4096. Dunno why technically that's desireable, but when I do SQL Server,
the DB admins are all over me if my records are too wide.