再次：数据类型Access 2003 [英] again: datatypes Access 2003
问题描述
我希望在一个字段中有大量文本，大小超过
64K。该字段将包含文本和HTML标记。有没有办法在
访问中执行此操作？
好吧，我可能需要更好地解释自己。我将在一个网页中有一个CMS（内容
管理系统），用户可以在ASP中提交表格之后粘贴大量文本
+ HTML标签文本+ HTML标签将
写入ACCESS数据库。
MEMO数据类型只允许64K，我需要添加超过64K。任何帮助？
谢谢
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
推荐答案
mbev写道：
mbev wrote:
我希望在一个字段中有大量文本，大小超过64K。该字段将包含文本和HTML标记。在
访问中有没有办法做到这一点？
好吧，我可能需要更好地解释自己。我将在一个网页上有一个CMS（内容管理系统），用户可以在其中粘贴大量文本
+ HTML标签，然后在ASP中提交表单后，此文本+ HTML标签将
写入ACCESS数据库。
MEMO数据类型只允许64K，我需要添加超过64K。任何帮助？
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?
将数据保存到文本或html文件中。在
Access表中放置一个指向该文件的超链接。
-
MGFoster ::: mgf00<在> earthlink< decimal-point> net
奥克兰，加利福尼亚州（美国）
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写道：
mbev wrote:
I我希望在一个字段中有大量大小超过64K的文本。该字段将包含文本和HTML标记。在
访问中有没有办法做到这一点？
好吧，我可能需要更好地解释自己。我将在一个网页上有一个CMS（内容管理系统），用户可以在其中粘贴大量文本
+ HTML标签，然后在ASP中提交表单后，此文本+ HTML标签将
写入ACCESS数据库。
MEMO数据类型只允许64K，我需要添加超过64K。任何帮助？
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?
将数据保存到文本或html文件中。在
Access表中放置一个指向该文件的超链接。
-
MGFoster ::: mgf00<在> earthlink< decimal-point> net
奥克兰，加利福尼亚州（美国）
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)
Access数据库只能达到2GB。备注字段可以达到2GB。
64KB是很多文本！但它适用于2GB备忘录
字段几次。
Access数据库不是从网络上输入数据的好主意，
如果可以避免的话。很难更新和备份，并且建议不要这么做。如果您计划拥有多个用户，那么您应该使用MSDE / SQL Server，或者将Jet
个线程的数量设置为1而不是3。 br />
你不能真正搜索或加入备忘录字段，所以如果你不是b $ b b b有很多数据，那么可能没有将
大型备忘录字段放入数据库的一大优势。由于这是HTML数据，你有没有想过将它作为HTM文件保存？
（david）。
" MGFoster" < me@privacy.com>在消息中写道
news：tA **************** @ newsread2.news.pas.earthli nk.net ...
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写道：
mbev wrote:
我想在一个字段中有大量文本，其大小超过
而不是64K。该字段将包含文本和HTML标记。有没有办法在访问时这样做
？
好吧，我可能需要更好地解释自己。我将在一个网页中有一个CMS（内容管理系统），用户可以在ASP中提交大量的
文本+ HTML标签，然后在ASP中提交表单+ HTML标签
将写入ACCESS数据库。
MEMO数据类型只允许64K，我需要添加超过64K。任何
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
帮助？
将数据保存到文本或html文件中。在
Access表中放置一个指向该文件的超链接。
-
MGFoster ::: mgf00< at> earthlink< decimal-point> net
奥克兰，加利福尼亚州（美国）
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)
这篇关于再次：数据类型Access 2003的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
