Importing tables from one database to another - help please!

[FatMan]

Hi all:
I have created a database and have distributed to about 50 clients but now
need to issue an update to the database. When distributed the database
contained a frontend and a backend. Now that I want to issue an update I
have discovered that I had left four tables in the frontend that should be in
the backend and only linked from the frontend.

What I would like to know is how do I move/import the four tables from the
frontend to the backend on the database that have been distributed to the
clients? I can do it on my own computer no problem; the challenge for me is
how to have this happen on the distributed copes.

My line of thought is to do this…
- Send out my update with the new frontend (call it FrontEnd2 for now)
- Create a subroutine on my start up form that will import the four
tables from
the old frontend to the backend.
- FrontEnd2 will have the tables with only a linked connection to the
backend.

I have used the following line of code to import a table into the current
database…

DoCmd.TransferDatabase acImport, "Microsoft Access", "Path\database.mdb",
acTable, "TableToBeImported", oldTableName

How do I import a table into a different database?

I am using MS Access 2000.

Any and all help is greatly appreciated.

Thanks,
FatMan

 

[John Spencer MVP]

First of all are the 50 clients all single users of the backend? If not, then
you have the problem of client A at site z and Client B at site Z having two
different sets of values in the four tables.

You can import tables to FrontEnd2 from FrontEnd1 and then Export from
FrontEnd2 to the backend. Once you have done that delete the table from
FrontEnd2 and create a link to the table in the backend.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County