tables in other file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jean-Paul - 14 Sep 2008 09:32 GMT

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

Reply to this Message

John Spencer - 14 Sep 2008 14:58 GMT

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
'====================================================

> Hi,
>
[quoted text clipped - 9 lines]
> Can somebody explain how this is done?
> Thanks

Reply to this Message

Jean-Paul - 14 Sep 2008 20:14 GMT

Perfect... thanks

> 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.
[quoted text clipped - 34 lines]
>> Can somebody explain how this is done?
>> Thanks

Reply to this Message