自动备份Access数据库 [英] Automatically backing up an Access database

问题描述

我们在网络驱动器上保存了一个Microsoft Access数据库.我要寻找的是能够每天或每周自动备份这些文件.最好的方法是什么?有人可以解释一下程序吗?

We have a Microsoft Access database saved on the network drive. What I am looking for is to be able to automatically backup these files on a daily or weekly basis. What is the best way to go about this? Can somebody please explain the procedure?

推荐答案

(大量借用我较早的答案之一此处 ...)

(borrowing heavily from one of my earlier answers here...)

re:实际执行备份

备份本机Access数据库仅是复制整个数据库文件的问题(对于Access_2003及更早版本，为.mdb；对于Access_2007及更高版本为.accdb).您可以使用任何喜欢的脚本语言，甚至是一个简单的Windows批处理文件，其功能类似

Backing up a native Access database is simply a matter of copying the entire database file (.mdb for Access_2003 and earlier, .accdb for Access_2007 and later). You could use any scripting language you prefer, even a simple Windows batch file that does something like

copy /Y d:\apps\databases\mydatabase.accdb z:\backups\databases\*.*

re:自动计划备份

Windows中的任务计划程序可以为您解决这些问题.创建脚本以复制数据库文件后，您可以创建计划任务以定期运行它.请参阅MSDN文章使用任务计划程序(Windows)，以获取更多信息.

The Task Scheduler in Windows could take care of that for you. Once you've created your script to copy the database file(s) you can create a scheduled task to run it periodically. See the MSDN article Using the Task Scheduler (Windows) for more information.

这篇关于自动备份Access数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！