A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

E-mail an entire database?



 
 
Thread Tools Display Modes
  #1  
Old July 17th, 2007, 02:36 AM posted to microsoft.public.access.gettingstarted
yael
external usenet poster
 
Posts: 8
Default E-mail an entire database?

I have a database with two tables and two forms that is an ongoing project
with a colleague. I would like to be able to e-mail it back and forth, but
her e-mail account rejects the attachment and I tried sending it to
myself--the same thing happens. Is there no way for both of us to see
exactly the same things in different places/different buildings?
Please help!!!
Thanks.
  #2  
Old July 17th, 2007, 04:04 AM posted to microsoft.public.access.gettingstarted
missinglinq via AccessMonster.com
external usenet poster
 
Posts: 545
Default E-mail an entire database?

A solution that I've seen in various sites is to simply rename the file with
an extention that is allowed. On the receiving end simply rename it back to .
mdb. An alternative, if allowed by your company's email, would be to zip the
file.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200707/1

  #3  
Old July 17th, 2007, 12:11 PM posted to microsoft.public.access.gettingstarted
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default E-mail an entire database?

Note, too, that MDB files tend to benefit immensely from compressing
(zipping). Give the .mdb file a different extension, compress it into a .zip
file and e-mail the .zip file.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"missinglinq via AccessMonster.com" u28780@uwe wrote in message
news:754996f8f2c6f@uwe...
A solution that I've seen in various sites is to simply rename the file
with
an extention that is allowed. On the receiving end simply rename it back
to .
mdb. An alternative, if allowed by your company's email, would be to zip
the
file.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200707/1



  #4  
Old July 17th, 2007, 02:40 PM posted to microsoft.public.access.gettingstarted
missinglinq via AccessMonster.com
external usenet poster
 
Posts: 545
Default E-mail an entire database?

I didn't know that, Doug! Why is that?

Douglas J. Steele wrote:
Note, too, that MDB files tend to benefit immensely from compressing
(zipping). Give the .mdb file a different extension, compress it into a .zip
file and e-mail the .zip file.

A solution that I've seen in various sites is to simply rename the file
with

[quoted text clipped - 3 lines]
the
file.


--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

  #5  
Old July 17th, 2007, 03:04 PM posted to microsoft.public.access.gettingstarted
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default E-mail an entire database?

Why is what? Why do .mdb file zip nicely? Just how the database is
structured in the file, I guess. Note that if you encrypt the file, you
won't get any benefit from zipping.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"missinglinq via AccessMonster.com" u28780@uwe wrote in message
news:754f233ddbd67@uwe...
I didn't know that, Doug! Why is that?

Douglas J. Steele wrote:
Note, too, that MDB files tend to benefit immensely from compressing
(zipping). Give the .mdb file a different extension, compress it into a
.zip
file and e-mail the .zip file.

A solution that I've seen in various sites is to simply rename the file
with

[quoted text clipped - 3 lines]
the
file.


--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com



  #6  
Old July 17th, 2007, 10:08 PM posted to microsoft.public.access.gettingstarted
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default E-mail an entire database?

"Douglas J. Steele" wrote:

Note, too, that MDB files tend to benefit immensely from compressing
(zipping). Give the .mdb file a different extension, compress it into a .zip
file and e-mail the .zip file.


I've encountered one or two places that either won't accept a zip file
or won't accept a zip file containing an exe. And of course, because
they assume it's a virus they don't bother telling you your email has
not been sent to the recipient.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
  #7  
Old July 17th, 2007, 10:28 PM posted to microsoft.public.access.gettingstarted
Douglas J. Steele
external usenet poster
 
Posts: 9,313
Default E-mail an entire database?

You can always rename the .zip file too.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Tony Toews [MVP]" wrote in message
...
"Douglas J. Steele" wrote:

Note, too, that MDB files tend to benefit immensely from compressing
(zipping). Give the .mdb file a different extension, compress it into a
.zip
file and e-mail the .zip file.


I've encountered one or two places that either won't accept a zip file
or won't accept a zip file containing an exe. And of course, because
they assume it's a virus they don't bother telling you your email has
not been sent to the recipient.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/



  #8  
Old July 18th, 2007, 01:37 AM posted to microsoft.public.access.gettingstarted
missinglinq via AccessMonster.com
external usenet poster
 
Posts: 545
Default E-mail an entire database?

Doug, you didn't say that "mdb file zip nicely" you said "MDB files tend to
benefit immensely from compressing." I wondered how/why they *benefit
immensly* form zipping. Just curious!

Douglas J. Steele wrote:
Note, too, that MDB files tend to benefit immensely from compressing
(zipping). Give the .mdb file a different extension, compress it into a

[quoted text clipped - 7 lines]

Tony


--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

  #9  
Old July 18th, 2007, 01:49 AM posted to microsoft.public.access.gettingstarted
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default E-mail an entire database?

"Douglas J. Steele" wrote:

You can always rename the .zip file too.


I did. That wasn't sufficient. Their anti virus scanner still
deleted the email.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
  #10  
Old July 18th, 2007, 01:50 AM posted to microsoft.public.access.gettingstarted
Tony Toews [MVP]
external usenet poster
 
Posts: 3,776
Default E-mail an entire database?

"missinglinq via AccessMonster.com" u28780@uwe wrote:

Doug, you didn't say that "mdb file zip nicely" you said "MDB files tend to
benefit immensely from compressing." I wondered how/why they *benefit
immensly* form zipping. Just curious!


Presumably there are a lot of partially empty data pages which should
have binary 00s written in them. Especially if you have memo fields
as each records memo is placed in their own page.

For a data MDB zips can compress at about a four or five to one ratio.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:05 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.