Attaching a 2003 Access data base to an email for use with Office

[TomC]

I was using Win XP with Office 2003 and have just installed Windows 7 and
Windows Live Mail with Office 2007. I have two other sites which also are
using Office 2003 and heretofore, we have had no problems emailing data bases
back and forth. But now, Windows Live Mail won't permit our exchanging .mdb
files as we have in the past. So, I was told that if we change the .mdb to
..txt we could email and get by Windows Live validation. That does get by the
validation, but I am having the problem of changing the .txt data base to
..mdb and getting it to open in Access. Any suggestions and help would be
greatly appreciated.
Tomc

 

[Steve]

Use WinZip (free download) to zip your .mdb file. Winzip is the standard for
file compression. You will have no problem emailing the zip file.

Steve
(e-mail address removed)

 

[TomC]

Steve. I did zip my data base and emailed it, and I did not have a problem
getting the email to bypass the Windows Live Mail exception - just like I had
no problem at that point when I changed the file type to txt. But I am
having the same problem and that is that Access will not let me open the
file. I tried copying and pasting but it wouldn't let me do that either.
Any suggestions as to how I can get Access 2007 to accept this file? Thanks,
Tomc

 

[TomC]

I should have added that it is WINDOWS 7 security that is pohibiting the
opening of the file with the .mdb file.
Tomc

 

[John W. Vinson]

I was using Win XP with Office 2003 and have just installed Windows 7 and
Windows Live Mail with Office 2007. I have two other sites which also are
using Office 2003 and heretofore, we have had no problems emailing data bases
back and forth. But now, Windows Live Mail won't permit our exchanging .mdb
files as we have in the past. So, I was told that if we change the .mdb to
.txt we could email and get by Windows Live validation. That does get by the
validation, but I am having the problem of changing the .txt data base to
.mdb and getting it to open in Access. Any suggestions and help would be
greatly appreciated.
Tomc

Right mouseclick the .mdb file in Windows Explorer and choose Send To....
Compressed (zipped) folder. This will create a .zip file that you can attach -
not only is it much smaller and therefore faster, but it will get by the
security.

 

[Steve]

Tom,

I don't have Windows 7 so am unfamiliar with its security. However, Access
2007 requires you to put your database file in a secure folder. Could that
be your problem?

Also, did you try John's suggestion?

Steve

 

[Gina Whipp]

TomC,

I have Windows 7 and have not had a problem opening the file as long as
Access 2007 knows it's in a Trusted Location...

http://www.regina-whipp.com/index_files/TrustedLocation.htm

However, I should also note that I detach the file and do not attempt to
open the file while still attached to eMail.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I should have added that it is WINDOWS 7 security that is pohibiting the
opening of the file with the .mdb file.
Tomc

 

[TomC]

Thank you Steve, Gina and John for your responses. John, I did do what you
suggested and it does get by the email part but Windows Security does not let
me do anything with the file once it is in Windows 7. I will try Gina's
suggestion. I hope that is the solution to my problem. Thanks again for you
time. Tomc

 

[TomC]

Gina, I must be doing something wrong, because I still can't get Windows 7,
Office 2007 to open the Office 2003 data base that I had attached to an
email. I made the Desktop a trusted location. I tried to open the data base
I had detached from an email after copying it to the Desktop. I tried both
attaching a zipped data base and a data base that I changed the extension to
..txt. Windows 7 wouldn't let me open either file??? First question I have
is how did you get the attached daba base by Windows Live and then how did
you move it to your trusted location before you opened it?? Would appreciate
your help on this.

 

[Steve]

Tom,

The Desktop is not a folder. Try making a legitimate folder a trusted
location then store your database file in that folder.

Steve

 

[Gina Whipp]

TomC,

Ummm, you can't trust the desktop... so fist create a folder or use one of
your existing folders but *Trust* a folder. Open you eMail and download and
detach your database to the folder. Once there, either rename it back .TXT
to .MDB or unzip it and then open it.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina, I must be doing something wrong, because I still can't get Windows 7,
Office 2007 to open the Office 2003 data base that I had attached to an
email. I made the Desktop a trusted location. I tried to open the data
base
I had detached from an email after copying it to the Desktop. I tried both
attaching a zipped data base and a data base that I changed the extension to
..txt. Windows 7 wouldn't let me open either file??? First question I have
is how did you get the attached daba base by Windows Live and then how did
you move it to your trusted location before you opened it?? Would
appreciate
your help on this.

 

[TomC]

Gina, I did create a Trusted Folder, included it in my Trusted locations and
placed my attachments into it and Windows 7 security still will not let me
open it. Windows Security does tell me that my security is set to medium and
then I looked all over and can't find out how to change my security setting
for the trusted folder to a lower level???
Tomc

 

[Gina Whipp]

TomC,

Was that Windows or Access? Do you get the message when trying to open the
Access database? Also, try turning off the UAC. Oh, a Trusted Folder is
just that, no security settings for it.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina, I did create a Trusted Folder, included it in my Trusted locations and
placed my attachments into it and Windows 7 security still will not let me
open it. Windows Security does tell me that my security is set to medium
and
then I looked all over and can't find out how to change my security setting
for the trusted folder to a lower level???
Tomc

 

[John... Visio MVP]

Sorry stevie, but in your finite wisdom, You are AGAIN wrong. The desktop is
a folder c:\user\<userid>\desktop

John...

 

[TomC]

Thanks Gina for replying to ALL my questions. I'm afraid I'm over my head,
because I don't know what UAC is or where to find it to turn it off. Please
help me on that and I'll try it. Here is the sequence of events that I have
been following. I highlight the attached file containing the 2003 zipped
data base and the only thing I can do with it is "Save As" which I do into my
Trusted Folder. In my Trusted Folder, I then try first to Extract it and
when that don't work, I then double click on it and in both cases I get this
"WINDOWS SECURITY WARNING" panel which says that "Windows has found that the
file is potentially harmful. To help protect your computer, Windows has
blocked access to this file." I have been getting this panel all along even
before creating the Trusted Folder and adding it to the Trusted Locations.
So I'm still in dire need of help. Thanks, Tomc

 

[Gina Whipp]

TomC,

That message is actually your eMail... Can you send one of these databases
that does not have personal/private information to me? What it sounds like
you are doing is not *completely* detaching from eMail... AND what eMail
program are you using, Windows Live Mall, Outlook, etc...?

Don't worry about the UAC for now as the message is not coming from there...

Also, are you zipping *before* you attach to eMail?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Thanks Gina for replying to ALL my questions. I'm afraid I'm over my head,
because I don't know what UAC is or where to find it to turn it off. Please
help me on that and I'll try it. Here is the sequence of events that I have
been following. I highlight the attached file containing the 2003 zipped
data base and the only thing I can do with it is "Save As" which I do into
my
Trusted Folder. In my Trusted Folder, I then try first to Extract it and
when that don't work, I then double click on it and in both cases I get
this
"WINDOWS SECURITY WARNING" panel which says that "Windows has found that the
file is potentially harmful. To help protect your computer, Windows has
blocked access to this file." I have been getting this panel all along even
before creating the Trusted Folder and adding it to the Trusted Locations.
So I'm still in dire need of help. Thanks, Tomc

 

[John W. Vinson]

Sorry stevie, but in your finite wisdom, You are AGAIN wrong. The desktop is
a folder c:\user\<userid>\desktop

And even that is Windows version dependent.

 

[Risse]

I was using Win XP with Office 2003 and have just installed Windows 7 and
Windows Live Mail with Office 2007. I have two other sites which also are
using Office 2003 and heretofore, we have had no problems emailing data
bases
back and forth. But now, Windows Live Mail won't permit our exchanging
.mdb
files as we have in the past. So, I was told that if we change the .mdb to
.txt we could email and get by Windows Live validation. That does get by
the
validation, but I am having the problem of changing the .txt data base to
.mdb and getting it to open in Access. Any suggestions and help would be
greatly appreciated.
Tomc

 

[TomC]

Gina, miracle of miracles, it finally worked. I don't know what I was doing
wrong, but after saving the zip file in the trusted folder, I was able to
open it. Thanks for your suggestions and your patience.
Tomc

 

[Gina Whipp]

TomC,

One less egg to fryyyy... one less database to reviewwww... Oh, no singing
allowed! I am happy it worked!

You're welcome!
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina, miracle of miracles, it finally worked. I don't know what I was doing
wrong, but after saving the zip file in the trusted folder, I was able to
open it. Thanks for your suggestions and your patience.
Tomc