Microsoft Access: Zipping a Data Base for Email

  • rogerbell / 204 / Wed, 24 Jun 2009 01:55:00 GMT / Comments (4)
  • I have a Data Base which is just over 9 Megs in size. When I zip the Data Base to send as an attachment, the size only reduces by a few bytes. I have used "Compact & Repair" which does not make any difference to the Zipping. Any help would be appreciated & Thanks
  • Keywords:

    zipping, data, base, email, microsoft, access

  • http://database.itags.org/ms-access-database/207243/«« Last Thread - Next Thread »»

    1. you could split the db and send as two separate attachments

      http://www.databasedev.co.uk/split_a_database.html
      Chris Hayes
      Still a beginner (only 12 years)

      "Roger Bell" wrote:

      > I have a Data Base which is just over 9 Megs in size. When I zip the Data
      > Base to send as an attachment, the size only reduces by a few bytes. I have
      > used "Compact & Repair" which does not make any difference to the Zipping.
      > Any help would be appreciated & Thanks

      cshayes | Sun, 01 Jun 2008 11:13:00 GMT |

    2. That sounds unusual. I usually see quite a bit of compression when zipping a
      database. In case there's any corruption in the database you could try
      creating a new blank database and importing everything from your existing
      database. Then compact the new db and see if it gets any smaller, and then
      zip it to see if it gets smaller.
      Paul Shapiro

      "Roger Bell" <RogerBell...discussions.microsoft.com> wrote in message
      news:8A8EA510-D51D-4707-81CC-F5C5B38C2FFF...microsoft.com...
      >I have a Data Base which is just over 9 Megs in size. When I zip the Data
      > Base to send as an attachment, the size only reduces by a few bytes. I
      > have
      > used "Compact & Repair" which does not make any difference to the Zipping.
      > Any help would be appreciated & Thanks

      paulshapiro | Sun, 01 Jun 2008 11:14:00 GMT |

    3. Check if you accidentally encrypted the database, the file will not shrink
      by much if you try and compress (zip) it..

      If you encrypted it...it will not compress.....
      go:

      tools->security->Encrypt/decrypt database.

      Albert D. Kallal (Access MVP)
      Edmonton, Alberta Canada
      pleaseNOOSpamKallal...msn.com

      albertd_kallal | Sun, 01 Jun 2008 11:15:00 GMT |

    4. use msn to send you db.

      walker | Sun, 01 Jun 2008 11:16:00 GMT |