Auto Backup of Split Database.

[HillTJ]

Hi, I wish to automatically (say on close of the database) backup both the FE & BE. I've seen some code but am unsure where to start. Appreciate any advice. Cheers.

 

[theDBguy]

Hi. Not everything you asked for but take a look at this. Hope it helps...

 

[GinaWhipp]

Why?

If the BE is on a Server then it gets backed up regularly, correct? And you should always have a master FE that can serve as a back up. Because you really don't want to attempt this if there is more than one person using the BE as that will quickly lead to errors and corruption.

Hmm, perhaps telling us why you think this important will help us understand.

 

[HillTJ]

GinaWhipp, you are correct. Upon reflection there is clearly no need for me to backup the FE-Master. The DBguys suggested code looks ideal for backing up the BE. I'll just need to figure a method of triggering it. Probably a button for now, but I'd be interested in other suggestions. Thanks.

 

[GinaWhipp]

Hmm, still wondering why you think the BE needs backing up. Doesn't the Server get backed up?

 

[HillTJ]

GinaWhipp, The server is regularly baked up. I guess I'm concerned about what to do if a BE table became corrupted. Is this something I should be concerned about?

 

[GinaWhipp]

Well, IF that happens then the most you should loss is a day depending upon whether there are incremental back-ups during the day.

IMHO, you have more chance of corrupting your own BE by having it back-up via some button. Too many things could go wrong.

I would check with IT and make sure the Server is backed up regularly and go from there. You can even ask about mirroring which some companies do which means you MIGHT lose a day but probably more like an hour.

 

[HillTJ]

GinaWhip, Excellent advice. Appreciate it. I agree, why introduce a BU routine that may in it'self cause a potential problem. Thanks.

 

[GinaWhipp]

You're welcome!

And remember, we're here in case you don't get a satisfactory reason from IT.

 

[HillTJ]

Pat, I've discovered the importance of regular back ups when developing an app. I currently do this manually but automating would be real neat. If you were prepared to publish your code with suitable recognition i'd bet others would also find it useful. Thanks

 

[Galaxiom]

Backing up Access while users are connected can be problematic.

If the data is critical consider changing the backend to a database server (eg MSSQL Server) which have much better facilities for backup and recovery.

 

[HillTJ]

Galaxiom, i do have code that displays users. I'll make sure that i check before doing any kind of backup. Thanks

 

[HillTJ]

Pat, thanks a lot. Cheers.