Automatically zip database

[mereclain]

Hello All,

I have a question. My department builds Access 'billing' database for our clients use. The database works fine but when it doesn't we ask the client to zip the database [and eventually get them to password protect the databases]. However, most our clients are Human Resources personnel so they are understandably illiterate when it comes to zipping/unzipping these databases.

Is there any VB code that can be used to do this? And, automatically attach password protected zipped file to an email to send to us?

I'm open for all suggestions... Thanks!

 

[mereclain]

Found the code

The code already exists for this. Sorry! :>)