Sue,
You would have to place the table you are interested
in e-mailing in a new database (copy the table and paste
it into the new database) to make easily deliverable.
Then you would attach the database to your e-mail and send
it.
These are ways that the table that is sent can
replace the old one in the destination databases.
A: You can have someone open the destination database,
and have them delete the old table, then have the user
simply copy the new table from the database you e-mailed
and paste it into the destination database. That is the
most simple unautomated way.
Another way to do the simple kind of import of a
table is to use the "Get External Data" option of the File
options to import the new table into the destination
database from the e-mailed one.
B: Or you can create a macro in your destination
database, that you can set as the property of the onclick
procedure of a button, of a form, in your database. In
that macro you can assign the actions of 1.use the
deleteobject action to delete the old table; 2. use the
TransferDatabase action to import the new table into the
database.
Note that the address of where the database that is
being imported from is a significant factor with this type
procedure and may differ from computer to computer. You
would probably want to keep the two databases
communicating the tables in the same immediate area (same
folder or base of directory for example). Also, when
trying to figure out paths to use to do imports, you might
want to create a shortcut to the database you want the
path of, then just look in the properties of the shortcut,
and to copy the path, and then paste it into your macro
specification as the database to be imported from.
Anyway, these are ways that you may want to try. I
recommend testing with the different ways to see which
ones work alright. The manual deleting of the original
table, and copying/pasting the new table into the
destination database to replace it is the simplest and
surefire, but you might want to try the macro. Test with
sample databases and decide which direction you would like
to go.
Also, note the deleting of a table does not affect
the queries that are built for it in a database, as long
as you replace the old table with one that has the same
exact structure and name of the old one.
Good luck, and I hope I was of some help.
Have a nice weekend.
Casey
