“记录太大”？ [英] "Record is too large"?
问题描述
任何人：
我有一个简单的MSAccess数据库，它是用旧的ASCII平面文件创建的。
除了刚刚开始发生的事情之外它工作得很好。我会在记录中输入
信息，保存记录，然后尝试移动到另一条记录，并获得访问错误记录太大的
。记录只有一半填充，
许多空字段。如果我删除添加的数据或删除一些旧数据，
然后它保存好并再次正常工作。每当我收到错误时，我就不会移动到数据库中的任何其他记录，直到记录为止。
''修剪''的数据。建议，任何人??
杰克
又名 te ***** @ earthlink .net
Anyone:
I have a simple MSAccess DB which was created from an old ASCII flatfile.
It works fine except for something that just started happening. I''ll enter
info in a record, save the record, and try to move to another record and get
an Access error "Record is too large". The record is only half filled, with
many empty fields. If I remove the added data or delete some older data,
then it saves ok and works fine again. Whenever I''m getting that error, I
can''t move to any other records in the DB until the record has been
''trimmed'' of data. Suggestions, anyone??
Jack
aka te*****@earthlink.net
推荐答案
FYI ...我添加数据到哪个字段或哪个表是什么并不重要
受到影响，每当我看似通过某个阈值时，我都会得到相同的错误信息。我在这里的任何MSAccess文档中都找不到错误信息，或者是任何解决记录大小限制的问题。我正在使用FORM
查看发生这种情况的时间。
" tekctrl" < te ***** @ earthlink.netwrote in message
news：Gv ************************* *****@earthlink.co m ...
FYI...it doesn''t matter what field I''ve added data to or which table is
affected, I get the same err msg whenever I appear to pass some threshold. I
can''t find that error msg in any of the MSAccess documentation that I have
here, or anything that addresses restrictions to a records size. I''m in FORM
view when this happens.
"tekctrl" <te*****@earthlink.netwrote in message
news:Gv******************************@earthlink.co m...
任何人：
我有一个简单的MSAccess DB是从一个旧的ASCII平面文件创建的。
除了刚刚开始发生的事情之外它工作正常。我会
Anyone:
I have a simple MSAccess DB which was created from an old ASCII flatfile.
It works fine except for something that just started happening. I''ll
在记录中输入
enter
信息，保存记录，然后尝试移动另一条记录和
info in a record, save the record, and try to move to another record and
get
get
a Access errorRecord is too large。记录只有一半，
an Access error "Record is too large". The record is only half filled,
，
with
许多空字段。如果我删除添加的数据或删除一些旧数据，
然后它保存好并再次正常工作。每当我收到错误时，我就不会移动到数据库中的任何其他记录，直到记录为止。
''修剪''的数据。建议，任何人??
杰克
又名 te *** **@earthlink.net
many empty fields. If I remove the added data or delete some older data,
then it saves ok and works fine again. Whenever I''m getting that error, I
can''t move to any other records in the DB until the record has been
''trimmed'' of data. Suggestions, anyone??
Jack
aka te*****@earthlink.net
您运行的是什么版本的Access以及MDB的大小文件？
-
总有不止一种方法给猫皮肤！
基于Access 2000/2003的答案/帖子
通过AccessMonster.com发布的消息
http://www.accessmonster.com/Uwe/For...ccess/200806/1
What version of Access are you running and how big is the MDB file?
--
There''s ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200806/1
tekctrl写道：
tekctrl wrote:
任何人：
我有一个简单的MSAccess数据库，它是用一个旧的ASCII平面文件创建的。
除了刚刚开始发生的事情之外它工作正常。我会在记录中输入
信息，保存记录，然后尝试移动到另一条记录，并获得访问错误记录太大的
。记录只有一半填充，
许多空字段。如果我删除添加的数据或删除一些旧数据，
然后它保存好并再次正常工作。每当我收到错误时，我就不会移动到数据库中的任何其他记录，直到记录为止。
''修剪''的数据。建议，任何人??
杰克
又名 te *** **@earthlink.net
Anyone:
I have a simple MSAccess DB which was created from an old ASCII flatfile.
It works fine except for something that just started happening. I''ll enter
info in a record, save the record, and try to move to another record and get
an Access error "Record is too large". The record is only half filled, with
many empty fields. If I remove the added data or delete some older data,
then it saves ok and works fine again. Whenever I''m getting that error, I
can''t move to any other records in the DB until the record has been
''trimmed'' of data. Suggestions, anyone??
Jack
aka te*****@earthlink.net
如果您提供错误编号，它可能对那些帮助您的人有帮助
作为错误消息。无论如何......这就是它在帮助中所说的。
"你定义或导入了一个记录大于2K的表。当您在记录中输入数据时，而不是在定义
表结构时，会发生此错误
。通过缩短某些字段来重新定义表格，
删除不需要的字段，或将某些字段移动到其他表格。
您可能有一个类似的文本字段陈述'设定为50个字符。设置它
到2.通过修改你的桌子来看看你还可以削减其他什么
结构。
牙买加日
http://www.youtube.com/watch?v= q6CqtOJraBA
这篇关于“记录太大”？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
