Send database via email?

[Gwen61]

When I access the list of email options, listed is either Excel, rtf, HTML, or text files.

If I want someone to take a look at the database I'm building, can I email it to them, and if so, how?

 

[pbaldy]

You wouldn't want to do it from within the database. Compact it, close it, then attach the mdb file to your email. You'd probably want to zip it first.

 

[Gwen61]

Thank you, pbaldy. For some reason (ignorance), I didn't think I could email the database as an attachment, like one can email other attachments, but I did send it and it seems to work. Thanks again.

 

[wazz]

sometimes .mdb files don't get through mail servers or firewalls (they don't like things that contain code sometimes). i rename the file extension to confuse them. MyDb.mdb would become MyDb.wazz. computer freaks out for a second and asks if i really want to do this. i say yes and send it off. you have to tell the person on the other end to rename the extension to .mdb. their computer will freak out too momentarily but then all is well. (i saw that someone else answered this question recently and they do the same thing. i thought it was you paul? maybe it was dcrake...)

 

[Mike375]

The standard email systems like Outlook Express and Windows Mail seem fine with anything as long as they are ticked to accept potentially troublesome attachments.

Outlook 2003 won't accept .mdb no matter what I have tried but zip seems fine.

I always prefer to use Zip rather than rename because a lot of people have trouble renaming the extensions but most seem OK extracting from Zip.

 

[Gwen61]

Thanks for the info, wazz & Mike. I sent the db the other day, and the person to whom I sent it still hasn't let me know if she was able to open it. When I hear from her, if she wasn't successful, I'll try zipping it.

 

[wiklendt]

I always prefer to use Zip rather than rename because a lot of people have trouble renaming the extensions but most seem OK extracting from Zip.

me too. there are a few computers at work which hide extensions ("example.zip" would appear as "example" in windows explorer) and if you try to simple add ".mdb" to it, you are effectively just making the name "example.mdb.zip" except that explorer doesn't show the .zip part.

i know how to change the settings in explorer, but these computers are set up differently and i can't for the life of me change it. it drives me nuts sometimes when i'm working on them b/c i find the extension so useful to have infront of me.

so if someone were to send me a renamed file, rather than a zip file, then i would need a different computer to acces the file properly (i can right click and "open with..." but sometimes that's just a pain in the ****).

 

[Mike375]

so if someone were to send me a renamed file, rather than a zip file, then i would need a different computer to acces the file properly (i can right click and "open with..." but sometimes that's just a pain in the ****).

Go to the CMD (DOS Prompt screen).

Assume the file is in a folder called MyDataBases.

At the DOS prompt type CD\MyDataBases and then the enter key and that will display C:\MyDataBases>

At the prompt type

ren full file name new file name

If you are not sure of what is there then type Dir/P at the prompt. The /P allows one page of the DOS screen to displat and Enter moves to the next.

But if you right click on the file in Explorer and then Properties you will get the extension

 

[wiklendt]

Go to the CMD (DOS Prompt screen)

well there you go. who would have thought - i remember doing EVERYTHING in DOS when i was little (like, 6-8 y.o.), and now i sometimes forget it's still there for me to use. thanks for the reminder, mike.