问题描述
由于我的一个客户从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
推荐答案
你有拆分前端/后端，对吗？如果没有，那么现在拆分
数据库！
话虽如此，表格过滤似乎不太可能是
造成这种情况。你的第一直觉 - 有些东西正在打断数据库
更新 - 更可能是正确的。如果你确定用户不会做愚蠢的事情，比如你提到的，使用任务管理器崩溃
访问，或关闭电脑电源开关，他们可能会报告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?
这篇关于按表单筛选导致损坏???的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！