By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,640 Members | 2,194 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,640 IT Pros & Developers. It's quick & easy.

again: datatypes Access 2003

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
10 Replies


P: n/a
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)

Nov 12 '05 #2

P: n/a
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)

Nov 12 '05 #3

P: n/a
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)

Nov 12 '05 #4

P: n/a
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)

Nov 12 '05 #5

P: n/a
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)


Nov 12 '05 #6

P: n/a
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)


Nov 12 '05 #7

P: n/a
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)



Nov 12 '05 #8

P: n/a
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)



Nov 12 '05 #9

P: n/a
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


Nov 12 '05 #10

P: n/a
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


Nov 12 '05 #11

This discussion thread is closed

Replies have been disabled for this discussion.