Bill said:
Dirk,
I might be heading for the edge of the cliff...
I need to automate via a user command button to
zip their "back-end" mdb and send it to a distribution
list taken from the applications user properties.
That doesn't sound too hard. You'll probably want to make sure that all
connections to the back-end are closed when you do this, or at least
that no one is actively updating the database.
Under normal circumstances, I would use WinZip in
batch mode (unless you know of a better way) to
zip the otherwise voluminous database. (I still have
to learn how to invoke WinZip from VBA, but I
have the idea that it isn't too involved.)
I gather that WinZip has a command-line interface, so you should be able
to use the Shell function to do that. Maybe you'll want to use the
ShellWait function from the Access Web. I think there may also be a
freeware zip compression library out there, also, but why not use WinZip
if you have it available?
However,
there's not much use in proceeding with the zip
process until I know how to get the zip file attached
to an e-mail via MAPI .
Any help along these lines would be GREATLY
appreciated.
The links I gave you should help you with that.
