Backup, Zip and email copy of the database programatically

Lateral

Registered User.
Local time
Yesterday, 19:30
Joined
Aug 28, 2013
Messages
388
Hi Guys

I need a way that I can simply have a User click a button on a form of the database and it will do automatically create a zip file of the entire database and start Outlook and attach the zip file and send it to me.....

Thanks for your help.

Regards
Greg
 
Hi,

As far as I'm aware you can't do that from within the active database, you need an external process to do that.

Have you tried searching this forum to see if others have tried.

Regards

John
 
Hi John

I have had a Google look around and can't really find anything...
 
Not being a smarty pant, but I just Googled, found some good hits, you need to compose it together..

First step : Copy the File..
Code:
    Dim fso As Object
    Set fso = VBA.CreateObject("Scripting.FileSystemObject")
    fso.CopyFile CurrentProject.Path & "\" & CurrentProject.Name, CurrentProject.Path & "\CopyToZip_" & CurrentProject.Name
Second Step : Copy the code for ZIPing files from Ron de Bruin's site.

Third Step : Lookup for email Code on this forum, should be PLENTY..
 
Last edited:
Thanks Paul,

I'll have a play and let you know how it goes......maybe you have a better Google than me ;)

Regards Greg
 

Users who are viewing this thread

Back
Top Bottom