How do you e-mail an Access Database

[Guy Delaney]

A friend populated an Access Database for me and then e-mailed it back to
me. IN my In Box, I can see that the e-mail has an attachment but when I
open the e-mail, no attachment is there.

I am using Microsoft Access 2003 with Service Pack 3 and Microsoft Outlook
2003 with SP3.

How can I retrieve this database which is in my e-mail but which is not
accessible.

 

[Tom van Stiphout]

On Sat, 18 Jul 2009 22:01:45 -0500, "Guy Delaney"

You compact the database, and then zip it.

-Tom.
Microsoft Access MVP

 

[Tom Wickerath]

Guy,

As Tom van Stiphout states, you can have your friend compact and zip the
database. Then have the person send the .zip file. It is also possible for
you to change the security settings on your PC, so that Outlook will not
block .mdb file attachements. Here is a KB article that shows how to do this:

You may receive an "Outlook blocked access to the following
potentially unsafe attachments" message in Outlook
http://support.microsoft.com/kb/829982

And here is an Office Online article that shows the attachment types blocked
by default in Office 2007. Many (if not all) of the same attachment types are
blocked by earlier versions of Outlook as well:

Blocked attachments in Outlook
http://office.microsoft.com/en-us/outlook/HA012299521033.aspx


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

:

You compact the database, and then zip it.

-Tom.
Microsoft Access MVP

__________________________________________

:

A friend populated an Access Database for me and then e-mailed it back to
me. IN my In Box, I can see that the e-mail has an attachment but when I
open the e-mail, no attachment is there.

I am using Microsoft Access 2003 with Service Pack 3 and Microsoft Outlook
2003 with SP3.

How can I retrieve this database which is in my e-mail but which is not
accessible.

 

[George]

Many email clients, including Outlook, consider Access mdb files to be
unsafe and will block them.
I've had success creating a compressed file (ZIP, RAR, etc.) from the mdb to
email as an attachment.

George

 

[Fred]

I send to a printing company who is not smart enough to figure what on there
end is reject them or to do / receive the above. I just rename the .mdb
extension to something else and then they change it back to .mdb