Create Zip File of Current Access Database & Email

Hello - Because of a major failure in our backup system, I would like to figure out how to create a zip file of the currently open Access database and then email it.

My goal here is to make sure I ALWAYS have a backup even when the backup process on the server fails.

I believe I have the email part without problem, but I have no idea how to create the zip file of the database running the code.

Can you please provide sample code on how to do this?

Thank you!
Who is Participating?
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
It will not be easy (if it is possible at all)  to run a utility on a currently open database.
Even if you could, you risk corruption.

You may have to close the db and do this as an external procedure...

You can also see this great utility:

rsburgeAuthor Commented:
Thank you for your help.  I really appreciate it.
Jeffrey CoachmanMIS LiasonCommented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.