Look into the built in Replication features of Access. Last time I
used it in production, it was icky, fussy and bloated tables. It also
worked. One of those deals with the devil. basically it allows you to
have disconnected updates merged back into a master DB through any of
several different communications paths.
MS Online writeup at:
http://office.microsoft.com/en-us/ac...526841033.aspx
Bone chancy.
The Access system contains two MDB files with ALL tables included in
one MDB, linked to the other MDB. There are two offices that run
different events, using the same Access system. The offices are not
connected by a LAN and run independently. Contact info is added and
changes are made to each office's DB. Once a year there is a desire to
merge these DBs so that the both offices can STARTt, once again, with
separate but identical DBs.
I'm trying to get a handle on the big picture. It looks like
Replication is what's needed. Perhaps one office could use a Global
replica, while the other could be use a local replica. Once a year the
local office's DB could be synchronized with the global office's DB.
Then a local replica could be made from that synchronized global DB,
which would replace the copy at the local office.
Do I have the big picture about right?
Is it necessary to make replicas of both MDB files, or just the back-
end MDB file?
Would it be better to merge the two MDBs before starting this
replication process?