VBA, Access File (mdb) Compress

DShan
#1 / 7

Access File (mdb) Compress

Does someone know of any utility (preferably free) to compress an Access
Data file (mdb) from CODE (VBA)? I need to compress my Archive Database
from Code and Unarchive whenever I need to import a Table or other Component
from the Archive Database.

Thanks in advance for the help!

Deep

Sat, 13 Oct 2001 03:00:00 GMT

Mark Walter
#2 / 7

Access File (mdb) Compress

Hi,

You can compact an Access DB from code,

Check out the CompactDatabase method of the DBEngine object.

The VBA would look something like:

DBEngine.CompactDatabase "MyDatabase.MDB", "MyTarget.MDB", dbLangGeneral

This would make a compacted copy of MyDatabase.MDB as MyTarget.MDB. You could
then KILL the original and rename MyTarget with the NAME command.

Quote:

> Does someone know of any utility (preferably free) to compress an Access
> Data file (mdb) from CODE (VBA)? I need to compress my Archive Database
> from Code and Unarchive whenever I need to import a Table or other Component
> from the Archive Database.

> Thanks in advance for the help!

> Deep

Sat, 13 Oct 2001 03:00:00 GMT

DShan
#3 / 7

Access File (mdb) Compress

There is a typo in the following message in the word "Unarchive", It
should be "UNCOMPRESS"

Sorry,

Deep

Quote:

>Does someone know of any utility (preferably free) to compress an Access
>Data file (mdb) from CODE (VBA)? I need to compress my Archive Database
>from Code and Unarchive whenever I need to import a Table or other
Component
>from the Archive Database.

>Thanks in advance for the help!

>Deep

Sat, 13 Oct 2001 03:00:00 GMT

DShan
#4 / 7

Access File (mdb) Compress

My question is about Compress not Compact. By Compress, I mean Zip and
UnZip. I am looking for some kind of compression utility like Winzip that I
could manipulate from code.

Deep

Quote:

>Hi,

>You can compact an Access DB from code,

>Check out the CompactDatabase method of the DBEngine object.

>The VBA would look something like:

>DBEngine.CompactDatabase "MyDatabase.MDB", "MyTarget.MDB", dbLangGeneral

>This would make a compacted copy of MyDatabase.MDB as MyTarget.MDB. You
could
>then KILL the original and rename MyTarget with the NAME command.

>> Does someone know of any utility (preferably free) to compress an Access
>> Data file (mdb) from CODE (VBA)? I need to compress my Archive Database
>> from Code and Unarchive whenever I need to import a Table or other
Component
>> from the Archive Database.

>> Thanks in advance for the help!

>> Deep

Sat, 13 Oct 2001 03:00:00 GMT

gHaD
#5 / 7

Access File (mdb) Compress

Quote:

> My question is about Compress not Compact. By Compress, I mean Zip and
> UnZip. I am looking for some kind of compression utility like Winzip that I
> could manipulate from code.

As far as I know, you can use a Shell command to run Winzip.

You'd get out of having to find another third-party control or having to figure
out the compression routines yourself....

--
+++++++++++++++++++++++++++++++++++++++
+++ gHaD (Aaron Robinson) +++
++ MJM-PC Solutions, Inc. ++
++ Chicago, IL ++
++ ++
++ -> ICQ# 5686832 <- ++
++ Remove the obvious from ++
++ the e-mail address ++
+++++++++++++++++++++++++++++++++++++++

Sat, 13 Oct 2001 03:00:00 GMT

Nolan
#6 / 7

Access File (mdb) Compress

deep,
u can either (code-wise) shell to DOS and run a pkzip command with the
appropriate params,
or, i heard that ther is an ActiveX control that does the same. Dunno if
it's free tho'

':-)

Quote:

> Does someone know of any utility (preferably free) to compress an Access
> Data file (mdb) from CODE (VBA)? I need to compress my Archive Database
> from Code and Unarchive whenever I need to import a Table or other
Component
> from the Archive Database.

> Thanks in advance for the help!

> Deep

Sun, 14 Oct 2001 03:00:00 GMT

Marco Smee
#7 / 7

Access File (mdb) Compress

I use a free extra program from WinZip 7.0 named:

<=== Command Line Support Add-On ===>

It works perfect with the shell commands.

Quote:

>Does someone know of any utility (preferably free) to compress an Access
>Data file (mdb) from CODE (VBA)? I need to compress my Archive Database
>from Code and Unarchive whenever I need to import a Table or other Component
>from the Archive Database.

>Thanks in advance for the help!

>Deep

___________________________________________________

Thu, 01 Nov 2001 03:00:00 GMT