Compress a database?

[LaPluma]

Hello

I have a MSAccess2000 database with about 2000 e.mail addresses in it over 5 or 6 fields. The database weighs about 21MB (!), and I wonder if it is possible to somehow compress the database before I upload it.

Many thanks

LaPluma

 

[WB786]

Have you tried to go to Tools and Run compact and repair otpion? This will reduce the size. Also if you are going to upload the data to a SQL server anyway you will want to run Compace and Repair afterwards as well, after deleting the local tables Access will create after upload.

-WB

 

[LaPluma]

Hello Wabeg

Thank you for your post.

Yes, I have tried the Compact & Repair option, but it didn't seem to make any difference.

It just seems that 2000 addresses seems to take up a massive amount of space - much more than I would have realised. Oh, well.........

Thanks again.

LaPluma

 

[LittleSmudge]

I have a database with almost 30,000 records in one of it's many tables and each record has a lot more besides names and addresses etc. So I dount its the data.

Are the Forms and Reports in this database as well ?
Are there any bit map images stored within any of the forms.

( I received a 4Mbyte database from a client recently what compacted down to < 300kByte when I removed the Co. logo from two forms and a report ! - They can go back in after development is complete.)



'ope-that-'elps.


G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.

Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need! :-D

 

[oharab]

If you are compressing the file for distribution, then the simple zip if good. Access databases have a lot of &quot;white space&quot; in them, so you can get good compression ratios, unless you have encrypted the file in which case there is no compression algorithm in the world which can make much of a difference.

HTH

Ben ----------------------------------------
Ben O'Hara

http://www.RobotParade.co.uk

----------------------------------------

 

[LaPluma]

Hello All

Many thanks for your helpful advice!

No bitmaps or reports and the database is used to send out e.mail messages monthly and to allow visitors to subscribe.

I didn't realise that the DB couldn't be compressed while it was open. I've tried compressing it again and managed to reduce its size from 21MB to 350KB. Amazing!

Thanks again!

LaPluma