backup db on exit using vba

[hardyd44]

Hi

Have searched but not really found anything that fits my needs !

I have access2003 DB that contains a lot vital information, but is still work in progress/Use, so don't want to split it yet

Now the problem, I would like it on exit to autobackup the DB to another PC on the network. I would prefer to do this via VB as then I can change it easily if a different PC is used as a backup machine.

any ideas ??

Thanks

 

[ghudson]

how about... Back up and zip code from ghudson

 

[hardyd44]

Thank you

Ghudson,

thank you - I was able to adapt that code to what I wanted, funny when I searched using backup as the search string it never turned, should try harder I think is the answer to that one.

anyway thank you again

Dean