S
sandrao
How can a have a scheduled back up of a Access database.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom Wickerath
Hi Sandra,
The easiest, and likely most reliable, method is to purchase a copy of Total
Visual Agent from FMS, Inc. It costs $299 for a single-user license:
Total Visual Agent
http://www.fmsinc.com/products/Agent/index.html
"Total Visual Agent Service: Total Visual Agent 2003 includes the option to
run the program as a Windows NT Service. This service runs even without a
user logged on to the computer, providing increased security and automated
restart if the machine crashes."
Otherwise, you can use the Microsoft Scheduler applet, along with some
Visual Basic script code, to automate your backups. This method will require
that you are always logged on, when the backup is scheduled to be done. If
you go with this method, I would try to write code to create separate backup
files, so that you don't possibly overwrite a perfectly good backup with a
file that might have some corruption that you have not yet detected.
Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
The easiest, and likely most reliable, method is to purchase a copy of Total
Visual Agent from FMS, Inc. It costs $299 for a single-user license:
Total Visual Agent
http://www.fmsinc.com/products/Agent/index.html
"Total Visual Agent Service: Total Visual Agent 2003 includes the option to
run the program as a Windows NT Service. This service runs even without a
user logged on to the computer, providing increased security and automated
restart if the machine crashes."
Otherwise, you can use the Microsoft Scheduler applet, along with some
Visual Basic script code, to automate your backups. This method will require
that you are always logged on, when the backup is scheduled to be done. If
you go with this method, I would try to write code to create separate backup
files, so that you don't possibly overwrite a perfectly good backup with a
file that might have some corruption that you have not yet detected.
Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
J
John W. Vinson
How can a have a scheduled back up of a Access database.
The simplest way is to do so completely externally of Access: use Windows
Scheduler to simply copy the .mdb/.mde file to a suitable location.
John W. Vinson [MVP]
S
sandrao
How would one go about this. What is a Windows
Scheduler and where is it located?
V
VladimÃr Cvajniga
You can find detailed information about Windows Scheduler in Windows help.
Vlado
Vlado
J
John W. Vinson
How would one go about this. What is a Windows
Start... Accessories... System Tools... Scheduled Tasks. It's a tool that runs
(as long as your computer is turned on and you're logged on) in the
background, and lets you run programs in batch on a schedule you can set.
John W. Vinson [MVP]
A
aaron.kempf
Correction
The easiest and most reliable solution would be to move to Access Data
Projects
SQL Server has enterprise-level backup and restore capabilities--
BUILT IN
The easiest and most reliable solution would be to move to Access Data
Projects
SQL Server has enterprise-level backup and restore capabilities--
BUILT IN