Zip mdb using Batch File

[benyod79]

I'm hoping someone will be able to assist with this one. Using a scheduling
program I'd like to run a batch file that runs a macro to creat e a copy of
the opened database. Then, using batch again, Zip that copied file to the
same directory location and delete the copied file.

The ultimate goal here is to create small sized back ups of the original
database. I have the first part (creating the copy mdb) working great. It's
zipping that copy that's giving me issues.

Any thoughts or suggestions is much appreciated!

Thanks

[Wayne Morgan]

You will need a DOS based (command line) zip utility. Once you have that,
use the command line recommended by the maker of the utility. If you have
WinZip, they have a free command line add-on. There are others.

--
Wayne Morgan
MS Access MVP
"benyod79" <u23098@uwe> wrote in message news:61dd747206000@uwe...

I'm hoping someone will be able to assist with this one. Using a
scheduling
program I'd like to run a batch file that runs a macro to creat e a copy
of
the opened database. Then, using batch again, Zip that copied file to the
same directory location and delete the copied file.

The ultimate goal here is to create small sized back ups of the original
database. I have the first part (creating the copy mdb) working great.
It's
zipping that copy that's giving me issues.

Any thoughts or suggestions is much appreciated!

Thanks

[usddcm]

http://www.info-zip.org/

Free command zip utility. Use it all the time to do exactly what your
looking to do except I do it in vbscript.

Wayne Morgan wrote:

You will need a DOS based (command line) zip utility. Once you have that,
use the command line recommended by the maker of the utility. If you have
WinZip, they have a free command line add-on. There are others.

--
Wayne Morgan
MS Access MVP
"benyod79" <u23098@uwe> wrote in message news:61dd747206000@uwe...

I'm hoping someone will be able to assist with this one. Using a
scheduling
program I'd like to run a batch file that runs a macro to creat e a copy
of
the opened database. Then, using batch again, Zip that copied file to the
same directory location and delete the copied file.

The ultimate goal here is to create small sized back ups of the original
database. I have the first part (creating the copy mdb) working great.
It's
zipping that copy that's giving me issues.

Any thoughts or suggestions is much appreciated!

Thanks

[benyod79 via AccessMonster.com]

Thank you both for your replies. Being somewhat new at DOS, the command line
utility's link was a bit overwhelming and I couldn't figure out what to
download. So after a few valliant, but unfruiful attempts, I chose to look at
WinRar's command line downloads (my zipping program). I'm still not getting
the results I'm looking for. The batch file I created is returning an error.
Here's exactly what I have so far all on one line:

"C:\Program Files\WinRAR\WinRaR.exe" "C:\Documents and Settings\Owner\My
Documents\Open Projects\Human Resources\DB Backup\Backup_of_HR_06-16.mdb" "C:\
Documents and Settings\Owner\My Documents\Open Projects\Human Resources\DB
Backup\Backup_of_HR_06-16.rar"

I'm getting this error message: No files selected. You need to select files
for this operation.

Any thoughts on this? Should I scrap the idea using WinRar and just use a
Windows Zipping utility?

Thanks for the help.

us****@yahoo.com wrote:

http://www.info-zip.org/

Free command zip utility. Use it all the time to do exactly what your
looking to do except I do it in vbscript.

You will need a DOS based (command line) zip utility. Once you have that,
use the command line recommended by the maker of the utility. If you have

[quoted text clipped - 19 lines]

>
> Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200606/1

[Wayne Morgan]

I looked at the WinRar help file to get the correct command line, try:

"C:\Program Files\WinRAR\WinRaR.exe" a "C:\Documents and Settings\Owner\My
Documents\Open Projects\Human Resources\DB Backup\Backup_of_HR_06-16.rar"
"C:\Documents and Settings\Owner\My Documents\Open Projects\Human
Resources\DB Backup\Backup_of_HR_06-16.mdb"

--
Wayne Morgan
MS Access MVP
"benyod79 via AccessMonster.com" <u23098@uwe> wrote in message
news:6206d88bd84eb@uwe...

Thank you both for your replies. Being somewhat new at DOS, the command
line
utility's link was a bit overwhelming and I couldn't figure out what to
download. So after a few valliant, but unfruiful attempts, I chose to look
at
WinRar's command line downloads (my zipping program). I'm still not
getting
the results I'm looking for. The batch file I created is returning an
error.
Here's exactly what I have so far all on one line:

"C:\Program Files\WinRAR\WinRaR.exe" "C:\Documents and Settings\Owner\My
Documents\Open Projects\Human Resources\DB Backup\Backup_of_HR_06-16.mdb"
"C:\
Documents and Settings\Owner\My Documents\Open Projects\Human Resources\DB
Backup\Backup_of_HR_06-16.rar"

I'm getting this error message: No files selected. You need to select
files
for this operation.

Any thoughts on this? Should I scrap the idea using WinRar and just use a
Windows Zipping utility?

Thanks for the help.

us****@yahoo.com wrote:

http://www.info-zip.org/

Free command zip utility. Use it all the time to do exactly what your
looking to do except I do it in vbscript.

You will need a DOS based (command line) zip utility. Once you have
that,
use the command line recommended by the maker of the utility. If you
have

[quoted text clipped - 19 lines]

>
> Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200606/1

[benyod79 via AccessMonster.com]

Thank you so much. That works beautifully. I'll try to follow your lead to
complete the rest of the code.


Wayne Morgan wrote:

I looked at the WinRar help file to get the correct command line, try:

"C:\Program Files\WinRAR\WinRaR.exe" a "C:\Documents and Settings\Owner\My
Documents\Open Projects\Human Resources\DB Backup\Backup_of_HR_06-16.rar"
"C:\Documents and Settings\Owner\My Documents\Open Projects\Human
Resources\DB Backup\Backup_of_HR_06-16.mdb"

Thank you both for your replies. Being somewhat new at DOS, the command
line

[quoted text clipped - 34 lines]

>
> Thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200606/1