How to make two separated files data always the same

[M.Miura]

There two separated MDB files that contain the same structured/named tables.
I would like to make every record value in those two tables always the same.

ex.

[mdb_file1]
table01
record1, record2, record3,,,,,

[mdb_file2] <-Different Location of course
table01
record1, record2, record3,,,,

then how?

any advice greatly appreciated.


M.M.

 

[John Vinson]

There two separated MDB files that contain the same structured/named tables.
I would like to make every record value in those two tables always the same.

By... what? Telepathy? Magic? If they are both independently
updateable and they are not connected, then there is NO way - no
possible way! - that your request can be attained.

What you *can* do is use Replication to *periodically* synchronize the
databases; you will need to establish some sort of connection in order
to do so. Replication is complex and not for the faint of heart! Get
the Replication White Paper from http://support.microsoft.com and
study it CAREFULLY; check out the suggestions at MichKa's excellent
site www.trigeminal.com; and *back everything up* before you start.

How "separated" are they? Different computers on the same high-speed
LAN? Different locations geographically? One on a laptop without net
access?

John W. Vinson[MVP]

 

[M.Miura]

Thanks advice,

Actually these two files are located in different directories on the same
server, so 1st I thought writing some VBScript to make the two matching, yet
if some simpler way available, that would be better for maintenance in the
2nd. Then...is it possible?

M.M.

 

[John Vinson]

Thanks advice,

Actually these two files are located in different directories on the same
server, so 1st I thought writing some VBScript to make the two matching, yet
if some simpler way available, that would be better for maintenance in the
2nd. Then...is it possible?

If they're on the same LAN... you can use a "split" database and share
the data directly.

Use Tools... Database Utilities... Database Splitter Wizard. This will
convert one of the databases into two - a "frontend" with all the
Forms, Reports, Queries, code, etc; and a "backend" with just the
tables.

This backend can be put on a shared directory, available to both (or
all, up to 255 theoretically) users, each of whom has a copy of the
frontend.

Records updated by one user will then indeed be instantly available to
the other, since there is no "synchronization" involved - they're both
using the exact same database.

John W. Vinson[MVP]