problem with "memo" size

[carbo20]

hello,
i built table useing memo var.
i need to paste in it alot of test.
the problem is that this is the biggest var, and still it is not big enough for
my use.
is there a solution for that problem?
thank you
nir

 

[o1110010]

the problem is that this is the biggest var, and still it is not big enough for my use.

Wow. More than 65,535 characters.. crazy. You'll probably have to use an OLE-DB.

 

[carbo20]

i will explain my use:

i am trying to build an error reports system.
so i have to copy and paste large parts of the report in each table cell.
i am new in access . what are my options?
thank you

 

[o1110010]

what are my options?

If the text data is larger than memo's data type, I believe the only option is an OLE Object. (Up to 1 gig!)

 

[neileg]

You could hold a hyperlink to the original file, perhaps?

 

[carbo20]

i already have hyperlink to the word file.
the idea is that every word doc is devided into 4 or 5 questions and answers.
my boss told me to make an application that got a record for each doc.
and a cell for each answer.
in that way i can search all the word doc's in one time.
(which is the perpose of the all application)
how can i work eith bigger text?

 

[neileg]

You need to upgrade to a newer version of Boss. Newer versions are more realistic about what applications can achieve.

Even if you solve this problem, perhaps by subdividing your documents into smaller chunks, you will have a huge amount of unindexed data that will take forever to search. You will end up with a monster application that works in theory but in practice is unuseable.

 

[carbo20]

i think just like you.
but i have nothing to do about it.
but anyway i am not the one who is gona use the db.
he will have to deal with it.