访问无法完成“压缩和修复".一台机器上 [英] Access unable to complete "compact and repair" on one machine

问题描述

我们已经将MS Access作为已调度的任务运行了多年，它是从大型机读取文件并打印出大量报告的.当然，它随每次调用而增长，因此它设置为紧凑并在退出时进行修复.

We've had MS Access running for years as a scheduled task reading files from a mainframe and printing out a bunch of reports. Of course, it grows with each invocation, so it is set to compact and repair on exit.

两周前，有一些东西破坏了该计算机上的Windows，负责这些事情的人决定在其上放上最新的企业标准映像".现在，在退出时，压缩和修复成功创建了优化的db1.mdb(，db2.mdb，... db99.mdb)，但是无法覆盖原始文件.事件日志中什么也没有，但是任务计划程序被告知发生了某些故障.

Two weeks ago, something trashed Windows on that machine, and the people in charge of such things decided to put the newest "corporate standard image" on it. Now, on exit, the compact and repair successfuly creates the optimized db1.mdb (, db2.mdb, ... db99.mdb), but fails to overwrite the original. Nothing in the event log, but the task scheduler is told that something failed.

网络搜索最初证实了我的怀疑，即运行该作业的帐户必须没有执行此任务的权限.但是，当我们解决此问题时，发现该帐户拥有完全控制权.进一步的实验表明，另外两个帐户也无法执行此操作，但是所有三个帐户都可以在另一台主机的同一目录中执行相同的数据库.

A web search initially confirmed my suspicion that the account running the job must not have permission to do this task. But when we went to fix that, we found that the account had full control. More experimentation revealed that two other accounts couldn't do it either, but all three accounts could do the same DB in the same directory on another host.

该目录位于联网的Windows文件服务器上，因此我想知道有关该主机的信息是否告诉文件服务器您不信任我".但是我不知道该如何检查，并且我愿意接受任何其他建议.

The directory is on a networked Windows fileserver, so I wonder whether something about that host is telling the fileserver "you can't trust me." But I don't know how to check that, and I'm open to any other suggestion.

推荐答案

找到的唯一解决方案是计划的任务，该任务调用Access宏删除原始文件，并重命名db1.mdb来替换它.

The only solution ever found was for the scheduled task that called the Access macro to delete the original and rename db1.mdb to replace it.

为避免灾难，它不会删除而不是删除，而是覆盖了存档中前一天的版本.

To avoid disaster, instead of deleting, it overwrites the previous day's version in an archive.

这不是正确"的解决方案，但是当找不到问题时，...

This is not the "right" solution, but when the problem cannot be found, .....

这篇关于访问无法完成“压缩和修复".一台机器上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！