Re: Any alternative to memo fields?

From: Pieter Wijnen (wijnen.nospam.please_at_online.no)
Date: 04/29/04

  • Next message: Chris: "ADO Transactions" 
    Date: Thu, 29 Apr 2004 19:09:55 +0200

    you have to use Oracle Or MSSQL to facilitate larger text fields (8000
    chars)
    another solution is to use a seperate table for the textfield where you use
    a linenumber field & text field to "emulate" one big text field
    linked to your table using the primary key

    hth

    Pieter

    "S N" <uandme72@yahoo.com> wrote in message
    news:e1Ax%23waLEHA.1144@TK2MSFTNGP12.phx.gbl...
    > I have an access database with many tables. Some of the fields to be
    entered
    > may contain more than 1000 characters of text/numbers.
    > IS Memo field the only alternative to storing such large amount of text in
    > MS Access. An
    > alternative to Memo fields is sought because it is said that Memo fields
    are
    > prone to
    > corruption?
    > I need this solution for a website with asp pages and MS Access database
    > which takes user entries from the webpages.
    >
    >
    >
    >

  • Next message: Chris: "ADO Transactions"

    Relevant Pages

    • Re: Any alternative to memo fields?
      ... another solution is to use a seperate table for the textfield where you use ... > I have an access database with many tables. ... > alternative to Memo fields is sought because it is said that Memo fields ...
      (microsoft.public.data.oledb)
    • Re: Any alternative to memo fields?
      ... another solution is to use a seperate table for the textfield where you use ... > I have an access database with many tables. ... > alternative to Memo fields is sought because it is said that Memo fields ...
      (microsoft.public.data.ado)
    • Error updating memo field in access database
      ... I have a access database that uses a couple of memo fields and have come to the conclusion that this is where my errors are coming from when trying to update/add new records. ... Microsoft JET Database Engine error '80040e07' ... Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching. ...
      (microsoft.public.data.ado)
    • Formatting Text in Reports
      ... I'm creating an Access database in which I need to have control over the ... format of text printed in reports from memo fields. ...
      (microsoft.public.access.reports)
    • Re: best way to search for multiple words through a query
      ... I want to search in text and memo fields of a table. ... If a field is a textfield than within that textfield the words should ... enter some search words...in your case RegExp. ... once you get the hang of it. ...
      (comp.databases.ms-access)
    • Quantcast