datatype in MS Access is very small

Results 1 to 2 of 2

Thread: datatype in MS Access is very small

  1. #1
    Join Date
    Dec 1969

    Default datatype in MS Access is very small

    Hi,<BR><BR>I am developing a &#039;Database driven search engine&#039; in asp. I am using MS Access as the Backend. I have a field named as &#039;Keywords&#039; in a table which stores all the keywords (text: seperated by comma as delimiter) of a perticular site. I want this field to accomodate around 1000 words if not more in a single record. Presently I am using "Memo" as the datatype for this field but this didn&#039;t help me. I dont want to move from MS Access if it can be done here. If not what are the alternate solutions. I highly appreciate if anybody can give a quick response.<BR><BR>Thanks<BR>sam

  2. #2
    Join Date
    Dec 1969

    Default Memo will allow..

    .. an unlimited (?maybe not unlimited, but I&#039;ve stored alot) amount of data in the field.<BR><BR>Show what you are doing and how you are having a problem.<BR><BR>You might also want to have a Keywords table that only stores one keyword per record and have multiple records per item.<BR><BR>-Doug

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts