tables in other file

J

Jean-Paul

Hi,

I split my mdb into a file with all code and one with all tables...
The first one is MP.mdb and the secodn one MP_data.mdb

Now I created a new table.
At this moment it is in the MP.mdb file, but I want it in the
MP_data.mdb file, linked to the code file.

I cvan not find a way to put one file in the MP_data file.

Can somebody explain how this is done?
Thanks
 
J

John Spencer

You should have created the table in the MP_Data.mdb. Since you didn't
the easiest way to do so is to follow the steps below.

++ Open up the MP_Data.mdb database
++ Select File: Get External Data: Import
++ In the file select dialog, find MP.mdb and click on it
++ Click on the table tab
++ Select the new table and click OK
++ Close MP_Data.mdb
++ Open MP.MDB in design view
++ Rename the new table (this is temporary)
++ Select File: Get External Data: Link Tables ...
++ In the file select dialog, find MP_Data.mdb
++ Select the table you just copied over into this database
++ Click OK
++ Test your database and if everything is working delete the renamed table.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 
J

Jean-Paul

Perfect... thanks

John said:
You should have created the table in the MP_Data.mdb. Since you didn't
the easiest way to do so is to follow the steps below.

++ Open up the MP_Data.mdb database
++ Select File: Get External Data: Import
++ In the file select dialog, find MP.mdb and click on it
++ Click on the table tab
++ Select the new table and click OK
++ Close MP_Data.mdb
++ Open MP.MDB in design view
++ Rename the new table (this is temporary)
++ Select File: Get External Data: Link Tables ...
++ In the file select dialog, find MP_Data.mdb
++ Select the table you just copied over into this database
++ Click OK
++ Test your database and if everything is working delete the renamed
table.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
Click to expand...
 
Top