Back-up and Recovery

[devlinp]

Hi,

I come with a mainframe background so please excuse me for my Ignorance on Ms-Access/VBA.

I am in the process of developing a solution using Access/VBA. I want to include custom Database Backup and Restore facility within my Application.


For example:

Say I take a backup of the Database before the monthly update and store the backup (in a folder).

After the update, if a user thinks that the monthly update did not go as he was expecting (this could be because of the data that he fed into the application) - I want to give a option asking user if s/he want to rollback to a previous version of the database. (This will be similar to Windows SYSTEM RESTORE facility).

The Database sits on a network drive (mostly this would be used by one user for the update part and may be 1-2 users who would be viewing the reporpts that come out of it)...So I can safely say it is a stand-alone, single user system.

What I would to ask your help is on following.

1. While my application is running how do I do the restore?
Or do I have to have a seperate application which performs this (ie., restore/backup) operation?
2. While my application is running, Can I take a backup copy of the Entire Database?


Any other hints/help regarding this would be much appreciated.

TIA,
PW.

 

[ghudson]

Welcome to the forum!

Searching the forum using the forums Advanced Seach function is a great way to discover and learn the answers to your Access programming questions.

Your questions have been asked and answered in many threads.

Seek and ye shall learn!

 

[devlinp]

Hi Ghudson,

I did do that before posting this. I could not get answers specific to my questions but most of them were to do with on broader topic of Backup/recovery. (Or I may be reading them wrong).

I will be grateful if anyone could give me answers/guidance on my specific qustions..

Thanks,
PD.

 

[ghudson]

Not that I doubt you but the answers to your questions are within this forum. Rolling the db back to a previous state could be disastrous. Making a copy [exporting] specific tables then offering the user the ability to replace a table could work if only one person were in the db and the process was well coded and thoroughly tested.

I will offer these two threads and let you decide how or if you want to use the information...

Back up and zip code

Export All Database Objects Into Text Files

And yes, I had to use the Advanced Search function to find those threads.

Good luck!

 

[devlinp]

Thank you!

I will crack on the lead you have given me. May be I will come back..if I am stuck.

Thank you once again.

This Forum is a real boon (for people like me!)

Cheers,
PW.

 

[harry4728]

Hey you should go through http://www.diskemergency.com atleast once as I think it will benefit you . It is one of the well known data recovery service provider which retrieve data .

 

[apr pillai]

Backing Up Database

For the Quick Back up Part you may check the following Link:

http://www.msaccesstips.com/2008/05/database-daily-backup.shtml