A memo field (or BLOB) can go to 2GB. 1GB using Jet 3.5
(Actually, the help file for Access 97 said '1.2' GB: it
depends how you count your GB!).
You may wish to use AppendChunk and GetChunk: some ODBC
drivers are not happy with very long SQL statements, and
I don't know what the maximum length of an SQL statement
or parameter is for ADO.
(david)
"mbev" <mbev@fakeemail.com> wrote in message
news:NAEgc.20541$A_4.3583@newsread1.news.pas.earth link.net...[color=blue]
> A MEMO field can go until 64K.
> With ASP is really to update, edit an delete records in an Access databae.
> Thanks
>
> "david epsom dot com dot au" <david@epsomdotcomdotau> wrote in message
> news:40830c39$0$27647$61ce578d@news.syd.swiftdsl.c om.au...[color=green]
> > An Access database can only go to 2GB. A Memo field can go to 2GB.
> > 64KB is a lot of text! But it fits several times into a 2GB memo
> > field.
> >
> > An Access database is not a good idea for data entry from the web,
> > if you can avoid it. It is difficult to update and backup, and
> > MS recommend against it. If you plan to have more than a few users,
> > you should use MSDE/SQL Server, or perhaps set the number of Jet
> > threads to 1 instead of 3.
> >
> > You can't really search or join on a Memo field, so if you don't
> > have a lot of data, there may not be a large advantage to putting
> > large memo fields into a database. Since this is HTML data, have
> > you considered persisting it as HTM files?
> >
> >
> > (david).
> >
> >
> > "MGFoster" <me@privacy.com> wrote in message
> > news:tADgc.1568$e4.1526@newsread2.news.pas.earthli nk.net...[color=darkred]
> > > mbev wrote:
> > >
> > > > I would like to have in a field a big amount of text with a size[/color][/color][/color]
more[color=blue][color=green]
> > than[color=darkred]
> > > > 64K. This field will have text and HTML tags. Is there a way to do[/color][/color]
> this[color=green]
> > in[color=darkred]
> > > > access?
> > > > Ok, I may be I need to explain myself better. I will have a[/color][/color]
> CMS(Content[color=green][color=darkred]
> > > > Management System) in a web page, where users can paste big amount[/color][/color][/color]
of[color=blue][color=green]
> > text[color=darkred]
> > > > + HTML tags then after submitting the form in ASP this text + HTML[/color][/color]
> tags[color=green]
> > will[color=darkred]
> > > > write to an ACCESS database .
> > > > The MEMO datatype only let me 64K and I need to add more than 64K.[/color][/color][/color]
Any[color=blue][color=green]
> > help?[color=darkred]
> > >
> > > Save the the data into a text or html file. Place a hyperlink in the
> > > Access table that points to the file.
> > >
> > > --
> > > MGFoster:::mgf00 <at> earthlink <decimal-point> net
> > > Oakland, CA (USA)
> > >[/color]
> >
> >[/color]
>
>[/color]
