Back Up Database Macro

[defosset]

what would the steps be to create a macro that when run it would close my data base and then back it up so if i ran it next time andif it got corrupted i revert to the saved database on the other drive. what macro functions do i need to use to accomplish this, i will be incorprating this into a switchboard button

Nick

 

[RobHudson]

Hi

I wanted to do this in the past, but never found an 'easy' way to do it. I ended up having a seperate DB. Then in the live DB looped all tables and copied them to the backup DB (using VBA). I had previously copied queries, modules and reports to the backup DB and made a mental note to manually re-copy if I changed them.

Not your ideal answer, but may help...
Good luck

 

[LittleSmudge]

See

http://www.tek-tips.com/viewthread.cfm?qid=936707

The issues are the same.

In addition:
If your databases are not part of you normal Backup system ( then WHY ? ) you'll probobly find it a lot easier to create a .bat file to do a simple File Copy on a schedule basis.


'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.