I would like to have in a field a big amount of text with a size more than
64K. This field will have text and HTML tags. Is there a way to do this in
access?
Ok, I may be I need to explain myself better. I will have a CMS(Content
Management System) in a web page, where users can paste big amount of text
+ HTML tags then after submitting the form in ASP this text + HTML tags will
write to an ACCESS database .
The MEMO datatype only let me 64K and I need to add more than 64K. Any help?
Thanks
10  2015 
mbev wrote: I would like to have in a field a big amount of text with a size more than
64K. This field will have text and HTML tags. Is there a way to do this in
access?
Ok, I may be I need to explain myself better. I will have a CMS(Content
Management System) in a web page, where users can paste big amount of text
+ HTML tags then after submitting the form in ASP this text + HTML tags will
write to an ACCESS database .
The MEMO datatype only let me 64K and I need to add more than 64K. Any help?
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)
mbev wrote: I would like to have in a field a big amount of text with a size more than
64K. This field will have text and HTML tags. Is there a way to do this in
access?
Ok, I may be I need to explain myself better. I will have a CMS(Content
Management System) in a web page, where users can paste big amount of text
+ HTML tags then after submitting the form in ASP this text + HTML tags will
write to an ACCESS database .
The MEMO datatype only let me 64K and I need to add more than 64K. Any help?
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)
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:tA****************@newsread2.news.pas.earthli nk.net... mbev wrote:
I would like to have in a field a big amount of text with a size more
than 64K. This field will have text and HTML tags. Is there a way to do this
in access?
Ok, I may be I need to explain myself better. I will have a CMS(Content
Management System) in a web page, where users can paste big amount of
text + HTML tags then after submitting the form in ASP this text + HTML tags
will write to an ACCESS database .
The MEMO datatype only let me 64K and I need to add more than 64K. Any
help?
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)
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:tA****************@newsread2.news.pas.earthli nk.net... mbev wrote:
I would like to have in a field a big amount of text with a size more
than 64K. This field will have text and HTML tags. Is there a way to do this
in access?
Ok, I may be I need to explain myself better. I will have a CMS(Content
Management System) in a web page, where users can paste big amount of
text + HTML tags then after submitting the form in ASP this text + HTML tags
will write to an ACCESS database .
The MEMO datatype only let me 64K and I need to add more than 64K. Any
help?
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)
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:40***********************@news.syd.swiftdsl.c om.au... 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:tA****************@newsread2.news.pas.earthli nk.net... mbev wrote:
I would like to have in a field a big amount of text with a size more than 64K. This field will have text and HTML tags. Is there a way to do
this in access?
Ok, I may be I need to explain myself better. I will have a
CMS(Content Management System) in a web page, where users can paste big amount of
text + HTML tags then after submitting the form in ASP this text + HTML
tags will write to an ACCESS database .
The MEMO datatype only let me 64K and I need to add more than 64K. Any
help?
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)
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:40***********************@news.syd.swiftdsl.c om.au... 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:tA****************@newsread2.news.pas.earthli nk.net... mbev wrote:
I would like to have in a field a big amount of text with a size more than 64K. This field will have text and HTML tags. Is there a way to do
this in access?
Ok, I may be I need to explain myself better. I will have a
CMS(Content Management System) in a web page, where users can paste big amount of
text + HTML tags then after submitting the form in ASP this text + HTML
tags will write to an ACCESS database .
The MEMO datatype only let me 64K and I need to add more than 64K. Any
help?
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)
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" <mb**@fakeemail.com> wrote in message
news:NA******************@newsread1.news.pas.earth link.net... 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:40***********************@news.syd.swiftdsl.c om.au... 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:tA****************@newsread2.news.pas.earthli nk.net... mbev wrote:
> I would like to have in a field a big amount of text with a size
more than > 64K. This field will have text and HTML tags. Is there a way to do this in > access?
> Ok, I may be I need to explain myself better. I will have a
CMS(Content > Management System) in a web page, where users can paste big amount
of text > + HTML tags then after submitting the form in ASP this text + HTML tags will > write to an ACCESS database .
> The MEMO datatype only let me 64K and I need to add more than 64K.
Any help?
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)
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" <mb**@fakeemail.com> wrote in message
news:NA******************@newsread1.news.pas.earth link.net... 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:40***********************@news.syd.swiftdsl.c om.au... 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:tA****************@newsread2.news.pas.earthli nk.net... mbev wrote:
> I would like to have in a field a big amount of text with a size
more than > 64K. This field will have text and HTML tags. Is there a way to do this in > access?
> Ok, I may be I need to explain myself better. I will have a
CMS(Content > Management System) in a web page, where users can paste big amount
of text > + HTML tags then after submitting the form in ASP this text + HTML tags will > write to an ACCESS database .
> The MEMO datatype only let me 64K and I need to add more than 64K.
Any help?
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)
Lot's of replies here talked about how you might be able to save the data to a
Memo field, but I say MGFoster's answer is the right one - don't. For one
thing, even though the database can hold it, you can't pass a blob that size
in one chunk through either DAO or ADO. You'll -have- to use the appendchunk,
getchunk methods which add complexity to your front-end code. Furthermore,
although an Access database can be up to 2GB in size, that's not all data,
there is some overhead, and I understand that performance drops steeply after
about 1GB of data. 1GB / 64K = 1632, so that's the maximum number you can
reasonably hold, and with the overhead I was talking about, figure that number
is more like 1000.
File systems were designed to handle big files implicitly. Jet databases were
designed to handle big Memos as a minor feature. The file system will be a
much better way to handle big blocks of data. Just keep pointers to the files
in Access.
On Sun, 18 Apr 2004 04:49:01 GMT, "mbev" <mb**@fakeemail.com> wrote: I would like to have in a field a big amount of text with a size more than
64K. This field will have text and HTML tags. Is there a way to do this in
access?
Ok, I may be I need to explain myself better. I will have a CMS(Content
Management System) in a web page, where users can paste big amount of text
+ HTML tags then after submitting the form in ASP this text + HTML tags will
write to an ACCESS database .
The MEMO datatype only let me 64K and I need to add more than 64K. Any help?
Thanks
Lot's of replies here talked about how you might be able to save the data to a
Memo field, but I say MGFoster's answer is the right one - don't. For one
thing, even though the database can hold it, you can't pass a blob that size
in one chunk through either DAO or ADO. You'll -have- to use the appendchunk,
getchunk methods which add complexity to your front-end code. Furthermore,
although an Access database can be up to 2GB in size, that's not all data,
there is some overhead, and I understand that performance drops steeply after
about 1GB of data. 1GB / 64K = 1632, so that's the maximum number you can
reasonably hold, and with the overhead I was talking about, figure that number
is more like 1000.
File systems were designed to handle big files implicitly. Jet databases were
designed to handle big Memos as a minor feature. The file system will be a
much better way to handle big blocks of data. Just keep pointers to the files
in Access.
On Sun, 18 Apr 2004 04:49:01 GMT, "mbev" <mb**@fakeemail.com> wrote: I would like to have in a field a big amount of text with a size more than
64K. This field will have text and HTML tags. Is there a way to do this in
access?
Ok, I may be I need to explain myself better. I will have a CMS(Content
Management System) in a web page, where users can paste big amount of text
+ HTML tags then after submitting the form in ASP this text + HTML tags will
write to an ACCESS database .
The MEMO datatype only let me 64K and I need to add more than 64K. Any help?
Thanks This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: John Bentley |
last post by:
John Bentley:
INTRO
The phrase "decimal number" within a programming context is ambiguous. It could
refer to the decimal datatype or the related but separate concept of a generic
decimal number....
|
by: Juris Krumins |
last post by:
Couple a weeks ago (19.08.03 Subject: Temporaty tables) I've posted message
with question about errors I'm getting while using create temporaty table
command.
So I'm start digging in src code as...
|
by: KePaS |
last post by:
I,ve got the following Script to Use on MS Access. So far it works
just fine, but I want to set "Auto-Increment" to the field
"test16_auto_long", but I don't know the expression Access wants to...
|
by: mbev |
last post by:
I would like to have in a field a big amount of text with a size more than
64K. This field will have text and HTML tags. Is there a way to do this in
access?
Ok, I may be I need to explain myself...
|
by: robin9876 |
last post by:
In an Access 97 (and 2000) database that has linked tables to Oracle
which is showing some fields as text when they are numbers in Oracle.
In Oracle they are specified to a size e.g. Number(38)....
|
by: madsen |
last post by:
Hi,
I am a developper who needs to return a collection of different
datatypes. Have considered using an array containing arraylists. Is it
posible? or is there a better way? Would like to use some...
|
by: |
last post by:
I'm working primarily in ASP and transitioning to
ASP.NET. This is probably entered to the wrong group but
I'm not sure of what precise database technology I'm
referencing.
I have written a...
|
by: Florian G. Pflug |
last post by:
Hi
We have again experienced data-corruption using 7.4.2 on an XFS Filesystem
on top of a software-raid (md) raid-1.
After a server crash last night (It was a rather strange crash - The...
|
by: Frank L |
last post by:
I have some accounting and tax receipting type applications, developed
for charitable and non profit groups, that are exhibiting strange
behaviour on a few of the 30 or 40 user machines.
When...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |
