E-mailing a mdb file

B

Bill Brinkworth

I am creating an application that the main operator will press a button, and
it will query certain info., package it in new table, e-mail it to a user, he
will update the data, send it back, and then the data will be updated into
the main table. Although I've haven't worked out all the details yet, a big
stumbling block is how Outlook 2003 will receive the data, as it currently
doesn't, unless the mdb file is renamed to *.doc or something. (Outlook 2003
will not receive access files - unless someone knows away to disable that
limitation). But if I do that, it wouldn't be easy for the user to open
Access automatically. Any one send and receive data back and have to do
anything like this? Your insight would be a blessing. (Yes, I know it should
be posted different place, but I wanted to get thoughts from Access
programmers)

Thanks in advance.......
 
R

Rick Brandt

Bill said:
I am creating an application that the main operator will press a
button, and it will query certain info., package it in new table,
e-mail it to a user, he will update the data, send it back, and then
the data will be updated into the main table. Although I've haven't
worked out all the details yet, a big stumbling block is how Outlook
2003 will receive the data, as it currently doesn't, unless the mdb
file is renamed to *.doc or something. (Outlook 2003 will not receive
access files - unless someone knows away to disable that limitation).
But if I do that, it wouldn't be easy for the user to open Access
automatically. Any one send and receive data back and have to do
anything like this? Your insight would be a blessing. (Yes, I know
it should be posted different place, but I wanted to get thoughts
from Access programmers)

Thanks in advance.......
Click to expand...

Welcome to the new world :)

Emailing files and not requiring some sophistication and knowledge from the
recipient of the Email I'm afraid has gone the way of the dinosaur. Even if
you can solve the problems with Outlook at your end there will likely be
issues at the recipient's end and usually you have zero control over that.

You'll need to either ZIP or rename the file. Just include good
instructions with the message on what needs to be done at their end.
 
C

chriske911

I am creating an application that the main operator will press a button, and
it will query certain info., package it in new table, e-mail it to a user, he
will update the data, send it back, and then the data will be updated into
the main table. Although I've haven't worked out all the details yet, a big
stumbling block is how Outlook 2003 will receive the data, as it currently
doesn't, unless the mdb file is renamed to *.doc or something. (Outlook 2003
will not receive access files - unless someone knows away to disable that
limitation). But if I do that, it wouldn't be easy for the user to open
Access automatically. Any one send and receive data back and have to do
anything like this? Your insight would be a blessing. (Yes, I know it should
be posted different place, but I wanted to get thoughts from Access
programmers)

Thanks in advance.......
Click to expand...

you could do this with an ex-/importing function
create a file and let the user put it on a share
then let him or her start up the ex-/import function

you can do this with csv, excel, xml and even html files if you require
a no brainer ex/import function
you could do it with a custom made format, usually a sequential flat
file and give this any extension you want
off course this requires some extensive coding

grtz
 
A

Avlan

Remember that XP recognizes ZIP-formats, so the receiving party has to
be seriously uncomfortable with computers to not know what to do.
 
Top