emailing access table

K

Kylie

Is it possible to email a table in access for a member of our team working
off site to work on? I have not been able to do this when attaching the file
as a simple attachment. I guess Access is a little more complex than this!
 
A

Arvin Meyer [MVP]

Many email programs will block anything that can contain code. I suggest you
zip the database and try emailing that.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Kylie said:
Is it possible to email a table in access for a member of our team working
off site to work on? I have not been able to do this when attaching the file
as a simple attachment. I guess Access is a little more complex than
this!
 
K

Kernow Girl

Hi Kylie -
If it is only a table within the DB you want to send you can easily use the
SendObject command to do so. Set up a Command Button with a macro attached.
In the macro use the SendObject command. Clic on the command button and off
it goes! It is very easy to use, I have set up a series of automated reports
with are sent each week, but you can send Tables, Queries, Forms, Reports,
Modules, etc. C
Hope this helps - Dika
 
K

Kylie

Hi

Thanks heaps for this. I have tried to set up a command button with the
SendObject command as the macro. When I click on the button on my form, it
opens up my email, however there is nothing attached to send. I guess that I
have missed out a step along the way somewhere. Any ideas??
 
K

Kylie

Hi Arvin

I zipped the file, however, when it is opened at the other end it is
read-only. I need the recepient to be able to work on the database and send
it back to me.

Do you have any ideas of how this would work?

Thanks
 
Top