Dictionary Database

Hi,
I am trying to build a online dictionary. I am using MS Access 2000 as backend and frontend as ASP.

The table will have two fields. 1)Definition 2) Meaning of the definition. Each field is defined as "text datatype.

In the second field some definitions will have more than 10 lines of text at 80 words per line including spaces. But Access supports only 250 words in one field maximum. Second field defined datatype is "text".In this case what should I do. How do I tackle this problem. Please can anybody help me.

Thankyou for your help.

Raghu

use 2 tables , one to keep definition and other for meanings, for example:

table 1
col1 = def_id <- Unique value
col2 = definition

table 2
col1 = def_id <- more than one definitions ID
col2 = meaning

So run queries like this one:
select t1.col2,t2.col2 from table1 t1,table2 t2 where t1.col1=t2.col1 and t1.col2 = [definition you want to look for]

It will return more than one row, what you need to do is to paste col2 from t2 in your HTML before displaying.


Hope this helps.


------------
Raghavendra at 3/25/01 1:53:25 AM


Hi,
I am trying to build a online dictionary. I am using MS Access 2000 as backend and frontend as ASP.

The table will have two fields. 1)Definition 2) Meaning of the definition. Each field is defined as &#34;text datatype.

In the second field some definitions will have more than 10 lines of text at 80 words per line including spaces. But Access supports only 250 words in one field maximum. Second field defined datatype is &#34;text&#34;.In this case what should I do. How do I tackle this problem. Please can anybody help me.

Thankyou for your help.

Raghu