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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS 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:


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rsburgeAuthor Commented:
Thank you for your help.  I really appreciate it.
Jeffrey CoachmanMIS LiasonCommented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.