Compressing a File

[Brandr]

I have a database (.mdb) file which is 10MB. Every month the file has to be sent out on a standard floppy disk- this is done in a vb program. The file is then taken from the disk and placed in the correct directory in another vb program on another computer.

I need to know how I can have vb compress this file from 10MB to fit onto a floppy disk (if this is even possible) on the first machine, and then have it uncompress it once it get to the other machine.

I'm using VB5 Enterprise edition. Thanks in advance for your support.

-Brandr Beekman
[email protected]

[oetje]

Check this site:http://www.xceedzip.com/ZIP.DLL.html

[Asaf_99]

I have no code for this but you can try here on WinFiles:
http://winfiles.cnet.com/apps/98/vb-comp.html
I think there should be some OCX there.

And besides, how come a database can be 10MB???
I hope I helped.

[Paul282]

why can't a database be 10mb?

it could be 100mb!

(And probably just as unlikely to zip to fit on a floppy )

you might have to span disks or go to a different media (Like MO disks or a Zip drive)

MO drives are great! (I just bought one) Zip drives are cheap!

[Brandr]

This database isn't that large in the scheme of things. I'm not sure about compression rates however - would I even be allowed to zip 10MB down to 1.44MB?

[oetje]

You can't zip it down to 1.44 MB. The best thing to do is buy a zip drive or something.

[Paul282]

just use win zip to zip it locally first and see what happens, you might be in luck. but if the DB is getting bigger then you'd need another solution soon anyway