按表单筛选导致损坏??? [英] Filter by Form causing corruption ???

问题描述

由于我的一个客户从A97 / W2000升级到A2003 / XP，他们已经没有结束数据损坏问题，主要涉及

主表之一。腐败可能导致一个记录的字段

变成中文字符。在运行紧凑/修复时，我可以看到腐败可能比我预期的更深，因为有时

索引丢失了，需要更换。


我曾经认为过度使用''ctrl-alt-delete''是个问题但

它仍在发生。所以现在我想知道使用filter-byform

是否会导致它。有一个大表格绑定到主表上面提到的

，他们使用逐个过滤的形式。将它更改为未绑定的

表格将是一场噩梦。


无论如何 - 有任何人对任何问题的看法/经验导致

在A2003 / XP下使用逐个过滤的形式，特别是如果它们之前没有

吗？


谢谢

Dave

Since upgrading one of my clients from A97/W2000 to A2003/XP they have
suffered no end of data corruption problems, mainly involving one of
the main tables. The corruption can result in one record''s fields
turning into chinese characters. On running the compact/repair I can
see that the corruption may be deeper than I expected because sometimes
indexes are missing and need to be replaced.

I used to think that overuse of ''ctrl-alt-delete'' was the problem but
it''s still happening. So now I''m wondering if the use of filter-byform
might cause it. There is a large form bound to the main table mentioned
above and they use filter-by- form a lot. Changing it to an unbound
form would be a nightmare.

Anyway - had anybody any views/experience of any problems cause by the
use of filter-by-form under A2003/XP, especially if they were''nt there
before ?

Thanks
Dave

推荐答案

***我不确定但也许你应该安装Service Pack 2或

后者，如果你已安装，请忽略此评论。

Hi,
*** I not sure but maybe you shall install Service Pack 2 or the
latter, If u already installed so ignore this remark.

由于我的上次评论而继续，

我在升级办公室的过程中也遇到了这个问题，但是我看到桌子的数据就像问号，就像我没有正确一样br />
字体，所以检查SP2或后者。

Continue due to my last remark,
I was encountered in that problem when upgrading my office too, but I
saw the table''s data was like question mark, like I dont have the right
font, so check for SP2 or latter.

" Dave G @ K2" <沓************* @ gmail.com>在消息中写道

news：11 ********************** @ g10g2000cwb.googlegr oups.com ...

"Dave G @ K2" <Da*************@gmail.com> wrote in message
news:11**********************@g10g2000cwb.googlegr oups.com...

自从我的一个客户从A97 / W2000升级到A2003 / XP后，他们没有遇到数据损坏问题，主要涉及主表之一。腐败可能导致一个记录的字段变成中文字符。在运行紧凑/修复时，我可以看到腐败可能比我预期的更深，因为有时索引缺失并且需要更换。

我曾经认为过度使用''ctrl-alt-delete''是问题，但它仍然在发生。所以现在我想知道使用filter-byform
是否会导致它。有一个很大的形式绑定到上面提到的主表，他们使用逐个过滤的形式。将它改为未绑定的形式将是一场噩梦。

无论如何 - 有任何人对A2003下使用逐个过滤器造成的任何问题的看法/经验/ XP，特别是如果他们之前都不在那里？

谢谢
戴夫

Since upgrading one of my clients from A97/W2000 to A2003/XP they have
suffered no end of data corruption problems, mainly involving one of
the main tables. The corruption can result in one record''s fields
turning into chinese characters. On running the compact/repair I can
see that the corruption may be deeper than I expected because sometimes
indexes are missing and need to be replaced.

I used to think that overuse of ''ctrl-alt-delete'' was the problem but
it''s still happening. So now I''m wondering if the use of filter-byform
might cause it. There is a large form bound to the main table mentioned
above and they use filter-by- form a lot. Changing it to an unbound
form would be a nightmare.

Anyway - had anybody any views/experience of any problems cause by the
use of filter-by-form under A2003/XP, especially if they were''nt there
before ?

Thanks
Dave

你有拆分前端/后端，对吗？如果没有，那么现在拆分

数据库！


话虽如此，表格过滤似乎不太可能是

造成这种情况。你的第一直觉 - 有些东西正在打断数据库

更新 - 更可能是正确的。如果你确定用户不会做愚蠢的事情，比如你提到的，使用任务管理器崩溃

访问，或关闭电脑电源开关，他们可能会报告Access正在崩溃吗？或者他们是否有网络故障？

有人开始使用无线连接吗？

You do have a split front-end/back-end, right? If not, then split that
database NOW!

Having said that, it doesn''t seem likely that filter by form would be
causing this. Your first instinct - that something is interrupting database
updates - is more likely to be correct. If you are sure that users aren''t
doing daft things like, as you mention, using the task manager to crash
Access, or turning the computer off at the power switch, are they perhaps
reporting that Access is crashing? Or are they having network glitches?
Has someone started using a wireless connection?

这篇关于按表单筛选导致损坏???的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！