how to make two tables' contents always the same

  • Thread starter Thread starter M.Miura
  • Start date Start date
M

M.Miura

Hi.

I would like to two tables' contents, those belong to different MDB and in
different directories but have the same name and the structure, always the
same. How can I set those tables' relation in-between? Any suggestion
greatly appreciated.
 
I would like to two tables' contents, those belong to different MDB and in
different directories but have the same name and the structure, always the
same. How can I set those tables' relation in-between? Any suggestion
greatly appreciated.
Click to expand...

Use just one table in one of the databases but create a link to it from the
other database. To do that, click on File then Get External Data then Link
Tables. Now choose the MDB database that has the table you want in it then
choose the table you want to link. Now any time you change the data with
either database open, the table in the other will automatically reflect the
changed data. One restriction is that, in order to make changes to the
table, you have to open the original database, not the one with the link in
it.

Tom Lake
 
Thanks Tom,

Yet in my case the server is not located on my desk top but in cyber space I
rent.
Is any method to do below. If needed, I can use ASP there.
 
Hi.

I would like to two tables' contents, those belong to different MDB and in
different directories but have the same name and the structure, always the
same. How can I set those tables' relation in-between? Any suggestion
greatly appreciated.
Click to expand...

It sounds like you may want to investigate "Replication", a method
whereby two databases can be kept in synch (over a local network, over
the Internet, or even on removable disks).

This is a complex and tricky subject. Go to

http://support.microsoft.com/default.aspx?scid=kb;en-us;182886

and download the FAQ, and study it with care. Other good resources can
be found at http://www.mvps.org/access and Michael Kaplan's site
http://www.trigeminal.com.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top