每周将脚本写入Clear Access DB [英] Write Script to Clear Access DB every week

问题描述

在我的测试设施中，我想编写一个脚本/宏，它将从本周的制作中每周自动清除/擦除测试结果。原因是每个月左右，Access DB被1000个测试结果阻塞，
关闭系统。然后，我必须手动转到该计算机并清除/擦除。

In my testing facility, I would like to write a script/macro that will clear/erase automatically the test results weekly from the week's production. The reason is that every month or so,  the Access DB gets clogged up with 1000s of test results and shuts down the system. I then have to manually go to that computer and clear/erase.

请告知最佳方法，或者如果有人已经这样做，请提供脚本。

Please advise on the best way to do this, or provide script if someone has done this already.

谢谢

推荐答案

您好，

此论坛适用于一般性问题以及与Microsoft Office相关的反馈。由于您的问题与脚本/宏更相关，我会将其移至更合适的论坛：

This forum is for general questions and feedback related to Microsoft Office. Since your question is more related to script/macro, I'll move it to a more appropriate forum:

https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=accessdev

我们建议适当发布的原因是您将获得最合格的受访者群体，而定期阅读论坛的其他合作伙伴可以分享他们的知识或从您与我们的互动中学习。感谢您的理解。

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Steve Fan

Steve Fan

这篇关于每周将脚本写入Clear Access DB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！