Prev: Can I tell whether Access was opened by Word?
Next: Conditional Formatting - Database performance
From: babs on 21 Apr 2010 08:37
My sister borrowed my computer and it out of town. I need to get a database
from it for a client(HELP). zipped up when you just rt. click on file and go
to send to zip is 40MB - It will not email-

I already compacted and repaired it and this is the size

Any ideas- is their any programs out there that will super compress???? a
file to be able to email it??

help
Thanks,
Barb
From: XPS350 on 21 Apr 2010 08:57
On Apr 21, 2:37 pm, babs <b...(a)discussions.microsoft.com> wrote:
> My sister borrowed my computer and it out of town. I need to get a database
> from it for a client(HELP).  zipped up when you just rt. click on file and go
> to send to zip is 40MB  - It will not email-
>
> I already compacted and repaired it and this is the size
>
> Any ideas- is their any programs out there that will super compress???? a
> file to be able to email it??
>
> help
> Thanks,
> Barb


Use a service like http://www.yousendit.com/ to send the file.

Groeten,

Peter
http://access.xps350.com
From: Paul Shapiro on 21 Apr 2010 08:57
"babs" <babs(a)discussions.microsoft.com> wrote in message
news:C7AFC9D5-F980-4368-AC8C-0721217E0219(a)microsoft.com...
> My sister borrowed my computer and it out of town. I need to get a
> database
> from it for a client(HELP). zipped up when you just rt. click on file and
> go
> to send to zip is 40MB - It will not email-
>
> I already compacted and repaired it and this is the size
>
> Any ideas- is their any programs out there that will super compress???? a
> file to be able to email it??

Sometimes creating a new blank db and importing all the objects from the
existing db will reduce the size. Especially if this db contains both the
data and the forms, code, etc. With the new db, do NOT open anything that
could cause code to run. That way the code remains uncompiled. Just import
all objects from the existing db, and then compact/repair the new db. If the
db has any code that runs automatically or forms that open automatically,
hold down the Shift key when doing the compact/repair to prevent the
automatic actions.

The current version of WinZip has more advanced compression options than
what is built into Windows. You didn't say how you're currently compressing,
but you could try the trial version if you are already close to your mail
service sending limit.

Maybe some of the free mail accounts offer larger file size limits than what
you're using now?

If that's not enough, the only option that comes to mind is storing the file
on a mutually-reachable server. If you don't have access to a server, there
are plenty of "cloud-based" options available. Microsoft has Live Drive, and
there are many others. I don't use them so I can't make a recommendation.

From: Daniel Pineault on 21 Apr 2010 11:01
My first thought would be to access an ftp connection to drop the file...,
but I'm assuming you don't have access to an ftp server, hence the question.

I like Paul's Idea of importing all you db ojects into a new db and then
performing a compile, compact and repair.

As for compressing file, 7-Zip has always had the best compression in my
experience using the native 7-Zip format (which mean both the sender &
recipient must have 7-Zip). You can get it, for free no strings attached at

http://www.7-zip.org

But even if you do manage to compress it more, I doubt you'll have enough of
a difference to being to e-mail it. Do you know what limit you ISP has for
single e-mail size? If it is 35MB, maybe you'll acheive it, but if it is
around 15-20MB I doubt you'll be able to gain that much just by improved
compression. In which case FTP is still your best option or Burn a CD and
mail it express (Cost a couple $$$ but they'll have it fast enough).
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"babs" wrote:

> My sister borrowed my computer and it out of town. I need to get a database
> from it for a client(HELP). zipped up when you just rt. click on file and go
> to send to zip is 40MB - It will not email-
>
> I already compacted and repaired it and this is the size
>
> Any ideas- is their any programs out there that will super compress???? a
> file to be able to email it??
>
> help
> Thanks,
> Barb
From: a a r o n . k e m p f on 21 Apr 2010 11:42
WinRar allows you to split archives into volumes of 10mb each

put them all back in the same directory, after emailing each slice
individually

and then right click and extract into a single directory



On Apr 21, 5:37 am, babs <b...(a)discussions.microsoft.com> wrote:
> My sister borrowed my computer and it out of town. I need to get a database
> from it for a client(HELP).  zipped up when you just rt. click on file and go
> to send to zip is 40MB  - It will not email-
>
> I already compacted and repaired it and this is the size
>
> Any ideas- is their any programs out there that will super compress???? a
> file to be able to email it??
>
> help
> Thanks,
> Barb

 |  Next  |  Last
Pages: 1 2
Prev: Can I tell whether Access was opened by Word?
Next: Conditional Formatting - Database performance