Any alternative to memo fields?

[S N]

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.

 

[Pieter Wijnen]

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