Compact-Repair-Backup-Compress

A

Adrian

Hello Group! good day!

Somebody has idea of since I can make a Button that shoots the following
actions?

1- That Repare/Compact DataBase
2- Soon makes a BackUp of the same one in a certain path
3- That Compresses same with RAR or Winzip or the similar requesting units
of Floppy disk.

Thanks!
 
M

Marshall Barton

Adrian said:
Somebody has idea of since I can make a Button that shoots the following
actions?

1- That Repare/Compact DataBase
2- Soon makes a BackUp of the same one in a certain path
3- That Compresses same with RAR or Winzip or the similar requesting units
of Floppy disk.
Click to expand...


Please, do not crosspost to so many groups. Many people
that respond to questions frequent multiple groups and will
see it if you only post to one or two groups.

The answer to your question is No, you can not reasonably
create such a button. The reason is that none of those
operations can be performed on an open database (you can not
even copy an open database file). A database file is a very
complex thing and the I/O that the database engine has to
perform to manage all the various required operations is not
something you can control, especially in a multi-user
environment.

The "proper" way to administer files, particularly databse
files, is to use a separate program/procedure and it's first
step should be verify that all users are closed out of the
file, the next step is to make a backup, then you can safely
perform the steps that you specified above.
 
A

Alex White MCDBA MCSE

create a batch file, I don't like the idea of compacting a database that is
open.

Use jetcomp to compact the database whilst it is not opened,

http://support.microsoft.com/?scid=kb;EN-US;273956

use the dos command xcopy within the batch file to copy the file

e.g.

xcopy %1 %2 /v/c/r

using the %1 and %2 (long time since I used these so double check)

means you can call the batch file like this

cleanbackzip.cmd c:\mydb.mdb d:\myback.mdb

so you are passing parameters.

did you know that winzip is based on opensource code (FREE) ?

it's called infoZip

http://www.google.com/search?q=InfoZip&hl=en&lr=&rls=GGLD,GGLD:2005-03,GGLD:en&sa=N&tab=gw

very easy to bind into a vba application.

I have never needed WinZip, get the InfoZip lib's

Sorry my post is a bit messy, I think I am coming down with the flu or
something not myself.

Post back if you need more help.
 
B

bonheurexpress

Adrian said:
Hello Group! good day!

Somebody has idea of since I can make a Button that shoots the following
actions?

1- That Repare/Compact DataBase
2- Soon makes a BackUp of the same one in a certain path
3- That Compresses same with RAR or Winzip or the similar requesting units
of Floppy disk.

Thanks!
Click to expand...
 
D

Doug F.

Yes, I would like some help please.
From VBA I need to compress a spreadsheet before emailing.
Luck with the flu.
Thanks.
 
Top