Question Access 2007 automatic backup

[malikge]

Hi,
I have crated a small application in Access 2007 and by using AccessRuntime, I have created a installer.
I want to know how can I take the backup of the data after it is installed on the client's machine.

 

[shadow9449]

How do you want it backed up? To the client's hard drive? To cloud storage?

Is it a single or multi-user application? If it's multi-user, may I assume that it's split and therefore only the back end needs to be backed up.

How often does it get backed up? Does the user have control or does the program just back itself up every time it's turned on, for example?

How many backups do you want to maintain? Do you have a hard number or does the user set this?

I'm just asking some questions about what you have in mind and if you can answer them, then I can tell you how I've implemented automatic backup.

SHADOW

 

[malikge]

How do you want it backed up

On client's hard drive

Is it a single or multi-user application?

It's a single-user application.

How often does it get backed up? Does the user have control or does the program just back itself up every time it's turned on, for example?

It should back up once a day. At the end of the day, and should be backed up itself.

 

[shadow9449]

What I would do is set it to back up when the user turns off the application.

What I've done is to adapt Albert Kallal's method of zipping the .mdb file:
http://www.kallal.ca/zip/index.htm

Create a backup folder and have it zip the file to that folder when the user turns off the application.

I've made really fancy versions that let the user specify how often to back up and how many backup files to maintain, and I've gone as far as having it move the zipped file to Dropbox (more about this in a minute) but this should give you some direction.

Copying to the user's hard drive will help if the database corrupts or the user screws up, but if the hard drive fails, or the computer is stolen or damaged, then you will have zero if you are only copying to the user's hard drive. That's why I've created backup routines in my applications that do all the above AND move the zipped file to Dropbox.

See if my instructions help you and feel free to ask the people for more direction.

Cheers

SHADOW

 

[malikge]

When I create a database in access 2007 it only creates a one file with .accdb extension.

After making the installer with AccessDeveloperExtensions,
I get the following files:

• autorun.inf
• setup.exe
• name..msi
• setup.ini

After installing the application by running setup.exe file, I get only one executable file with .accdr extension
Can you please tell me how to adapt Albert Kallal's method of zipping and un-zip the database?
Or any other technique?

 

[malikge]

I have managed to adapt Albert Kallal's method of zipping and un-zip the database.

Now can anyone tell me or give any hint on how to make backup automatically when the application is closed.

 

[shadow9449]

I have managed to adapt Albert Kallal's method of zipping and un-zip the database.

Now can anyone tell me or give any hint on how to make backup automatically when the application is closed.

It sounds like you're getting close.

What I would do is create a hidden form that opens with the program. In the On Close method of the form put the code to zip the database. That way when the user turns off the program, it zips itself to wherever you have set.

Get it?

SHADOW

 

[RainLover]

Hi,
I want to know how can I take the backup of the data after it is installed on the client's machine.

Please explain further.

If "Take " means Copy then what is the difference between this and any other Database Back End.

 

[RainLover]

The quick or the dead.

Looks like Shadow has this under control.

 

[malikge]

In the On Close method of the form put the code to zip the database

With the code you mean in "VBA"?

 

[shadow9449]

With the code you mean in "VBA"?

That is correct

 

[RainLover]

Malikge.

Are you sure this is what you want to do.

If the Client's Hard Drive Fails then you have lost everything.

Why do you not have the Data on the server as the server should be automatically backed up every night.

I think I am missing something here but making a copy to the C;|Drive everytime the application closes does not appear to be a good/safe practice.

 

[malikge]

Why do you not have the Data on the server as the server should be automatically backed up every night.

How can I put data on server?
This application will run on a single PC.

 

[RainLover]

Q1.

Is this computer stand alone or on a network.

Q2.

Have you split the Database into a Front End Back End situation.

 

[shadow9449]

I've put into my applications a script that backs up the back end and then moves it to Dropbox. That way there's no problem if anything fails. I asked the original poster what his goal was and he said that it's on a single computer and single user and wants to back it up locally so I've responded accordingly

SHADOW

 

[RainLover]

Shadow

It would be nice to have the OP answer the questions.

 

[malikge]

I have found a solution.
thanks anyway...