[AccessD] Automate backup

[James Button]

Depending on the concurrency activities - 
You may have problems with a .bat or other scheduled process getting access to
the file when a particular user closes the file

- OK convoluted maybe but what seems to be a simple process is complicated by
the OS - 

A script initiated at the opening of the file - which could be a .cmd script
that does the open for the user, and then - either after a set interval, or as
the next running task in the script
Initiates a backup process such as robocopy?
That facility will need to wait, or have a delay loop facility to hold off the
processing until it can get exclusive use of the database file
And also stop multiple copies of the script from running concurrently, or being
scheduled 
As in once it is scheduled to run all other attempts to start it get ignored, or
voided.

And - there is then the time when user 1 finished using the file and the backup
started  so user 2 (or even user 1) cannot immediately access the database.

JimB


-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Charlotte Foust
Sent: Friday, March 3, 2017 4:36 PM
To: Access Developers discussion and problem <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Automate backup

How about an auto close macro?  I'm not sure how you would trigger a task
based on the database closing.

Charlotte Foust
916-206-4336

On Mar 3, 2017 7:25 AM, "FW Salato Center" <Salato at ky.gov> wrote:

> I have a small 2007 database on a shared drive that only a few people
> access infrequently. I need to upgrade it to 2016, but that shouldn't be
> too bad. I also want to add a routine that creates a backup automatically
> when the accdb file is closed - regardless of how it's closed. The db isn't
> split - I know... I know... but trust me... in this case, it just isn't
> warranted.
>
> The interface now has an option to create a backup, so it shouldn't
> require a lot of work, but I'm not finding any code snippets for this -
> everything I've found is old and insanely convoluted.
>
> Any help?
>
> Susan H.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com