E-mail an entire database?

[Yael]

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.

 

[missinglinq via AccessMonster.com]

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.

 

[Douglas J. Steele]

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.

 

[missinglinq via AccessMonster.com]

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

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.

 

[Douglas J. Steele]

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

(no e-mails, please!)

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

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.

 

[Tony Toews [MVP]]

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/

 

[Douglas J. Steele]

You can always rename the .zip file too.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

 

[missinglinq via AccessMonster.com]

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!

[quoted text clipped - 7 lines]

Tony

 

[Tony Toews [MVP]]

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/

 

[Tony Toews [MVP]]

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/

 

[David W. Fenton]

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

Doesn't any active developer have a web page on which she can post
downloads? It's certainly much more efficient than email
attachments.

 

[Tony Toews [MVP]]

Doesn't any active developer have a web page on which she can post
downloads? It's certainly much more efficient than email
attachments.

No, email is more efficient. Click reply to someone in my email
software, drag and drop the file and hit Send. For a web page means
I'd have to drag and drop the file to the specific folder, then
publish the website, then ensure I have the right URL and then Reply,
paste and hit send. We're talking ten seconds instead of a minute or
two.

In this case it was an update to the Auto FE Updater I wanted just to
see if I had fixed a bug.

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/

 

[David W. Fenton]

No, email is more efficient.

Not in terms of bytes sent over the wire.

Click reply to someone in my email
software, drag and drop the file and hit Send. For a web page
means I'd have to drag and drop the file to the specific folder,
then publish the website, then ensure I have the right URL and
then Reply, paste and hit send. We're talking ten seconds instead
of a minute or two.

Sounds like you make your life too difficult in managing your
website. I would just open my FTP program and upload the zip file to
the destination folder. I know the URL already, so typing it is no
big deal.

If find it much easier in general with some of my clients to have
them download a file because they are not tempted to open it in
place as they are with email attachments. Some people have real
trouble understanding the difference between a email attachment and
a file stored in a particular location on their hard disk or server.
I've particularly seen very intelligent people lose lots of work in
Word documents attached to email because they worked in the
attachment then didn't save when they closed the email message, and
thus lost all their edits in the Word document.

 

[Tony Toews [MVP]]

Not in terms of bytes sent over the wire.


Sounds like you make your life too difficult in managing your
website. I would just open my FTP program and upload the zip file to
the destination folder. I know the URL already, so typing it is no
big deal.

If find it much easier in general with some of my clients to have
them download a file because they are not tempted to open it in
place as they are with email attachments. Some people have real
trouble understanding the difference between a email attachment and
a file stored in a particular location on their hard disk or server.
I've particularly seen very intelligent people lose lots of work in
Word documents attached to email because they worked in the
attachment then didn't save when they closed the email message, and
thus lost all their edits in the Word document.

To each their own.

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/

 

[Arvin Meyer [MVP]]

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?

Besides emailing a zip file, you can use terminal services to connect
directly to the database (and even edit it). You must have admin permissions
to do that. You can also use a program like WinConnect to do it without
admin permissions (after setup):

http://www.thinsoftinc.com/index.aspx

 

[Spurious Response]

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

Tony

Instead of merely archiving it, encrypt it with the zip or rar app.

Then the scanner should let it pass.

 

[Spurious Response]

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.

What one should encrypt is the zip file. That'll stop those nasty
scanners from seeing things like visual basic scripts in the zip file.

 

[Tony Toews [MVP]]

Instead of merely archiving it, encrypt it with the zip or rar app.

Then the scanner should let it pass.

Or the scanner may still delete it simply because it is a zip file. A
rar might go through.

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/