紧凑和修复 - 从功能区菜单项或计时器启动 [英] Compact and Repair - initiate from a Ribbon Menu item or by timer

问题描述

为管理用户提供压缩和修复后端数据库选项的最简单方法是什么？

What is the easiest way to provide an administrative user with the option to Compact and Repair the backend database ?

我是否需要使用Shell32.exe来执行此操作？换句话说，关闭前端，触发一个shell命令来启动存储在后端数据库中的特殊脚本？
$


在这里寻找想法.. ..后端由10个用户共享....并且他们每天自动从后端断开连接。理想情况下，C& R应该在所有用户注销时在晚上完成...所以我也在考虑基于计时器的执行。

Do I need to employe Shell32.exe to do this ? In other words, close the front-end, fire off a shell command to start-up a special script stored on the backend database ?

Looking for ideas here....the backend is shared by 10 users....and they are automatically disconnected from the backend daily. Ideally, the C&R should be done at night when all users are logged off...so I am also thinking about a timer-based execution.

推荐答案

使用Windows计划任务执行一个简单的批处理文件，在半夜没有人进入数据库时​​，调用/ compact命令行开关。

Use a windows Scheduled Task to execute a simple batch file, in the middle of the night when no one will be in the database, that invokes the /compact command line switch.

这篇关于紧凑和修复 - 从功能区菜单项或计时器启动的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！