how to make two tables' contents always the same

[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.

 

[Tom Lake]

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.

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

 

[M.Miura]

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.

 

[John Vinson]

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.

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