Prev: Report has more records than source data
Next: Outlook 2007 and Access
From: m galvin on 2 Apr 2010 11:26
How can I make this automatic when the db is closed?
From: Stephen Raftery on 2 Apr 2010 12:31
One way might be to call the db from a batch file, and end the batch file
with a call to your backup program.

Another possibility might be to put a line in the Close event of your
Switchboard form which calls the backup program when the form closes.


"m galvin" wrote:

> How can I make this automatic when the db is closed?
From: Tom van Stiphout on 2 Apr 2010 12:34
On Fri, 2 Apr 2010 08:26:02 -0700, m galvin
<mgalvin(a)discussions.microsoft.com> wrote:

You can use the Windows Scheduler to schedule a task to perform the
backup. In most companies that's done overnight.

-Tom.
Microsoft Access MVP


>How can I make this automatic when the db is closed?
From: m galvin on 2 Apr 2010 14:39
When you say "which calls the backup program when the form closes", would
this be via code or possibly a macro? If code, what would the code be?

"Stephen Raftery" wrote:

> One way might be to call the db from a batch file, and end the batch file
> with a call to your backup program.
>
> Another possibility might be to put a line in the Close event of your
> Switchboard form which calls the backup program when the form closes.
>
>
> "m galvin" wrote:
>
> > How can I make this automatic when the db is closed?
From: Daniel Pineault on 2 Apr 2010 16:21
The key thing to remember when performing a backup is that no one can be
using the database at the time or the backup may end up corrupt.

As such, as Tom mentioned, using a bacth file in conjunction with the Task
Scheduler can be a good approach. Perform your backup when 99.9999% chance
that no one will be using the db (say 2:00am).

Below is a good post on the subject (batch file code)
http://groups.google.ca/group/microsoft.public.access/browse_thread/thread/4c8841ec5163aba8/380f102d443e52df?hl=en&q=ms+access+backup

Another approach using vba code within your database is viable also, a good
source for this can be found at
http://www.pointltd.com/Downloads/Details.asp?dlID=49

--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"m galvin" wrote:

> How can I make this automatic when the db is closed?
 |  Next  |  Last
Pages: 1 2
Prev: Report has more records than source data
Next: Outlook 2007 and Access