Re: Any alternative to memo fields?
From: Pieter Wijnen (wijnen.nospam.please_at_online.no)
Date: 04/29/04
- Next message: Broox: "0x8000FFFF "Catastrophic failure" Message with VFPOLEDB"
- Previous message: Yuancai \(Charlie\) Ye: "Re: Migrating to OLEDB"
- In reply to: S N: "Any alternative to memo fields?"
- Messages sorted by: [ date ] [ thread ]
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: Broox: "0x8000FFFF "Catastrophic failure" Message with VFPOLEDB"
- Previous message: Yuancai \(Charlie\) Ye: "Re: Migrating to OLEDB"
- In reply to: S N: "Any alternative to memo fields?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
