Update database - Synchronization?

A

Arch

I am sure there is an easy answer to this, I just don't know it. I have a
"master" database, that will be used to work on changes to the database
structure. I will also have three "replicas" on different computers, with
different users, and in no way connected, they will also have VERY DIFFERENT
RECORD SETS. How can I update each of the other users, when the database
structure is updated, without losing their recordsets. Keep in mind the
three are not connected, nor can they be.

thanks,

Archie
 
J

John Vinson

I am sure there is an easy answer to this, I just don't know it. I have a
"master" database, that will be used to work on changes to the database
structure. I will also have three "replicas" on different computers, with
different users, and in no way connected, they will also have VERY DIFFERENT
RECORD SETS. How can I update each of the other users, when the database
structure is updated, without losing their recordsets. Keep in mind the
three are not connected, nor can they be.
Click to expand...

If you're updating the structure of the user interface - new forms,
queries, or reports - go to a "split" database architecture. This has
each user working with two databases - a frontend containing these,
and a "backend" containing only the tables, with links between them.
Tools... Database Utilities... Database Splitter Wizard will set this
up for you.

With this design, you can simply send the user a new frontend; they
delete their current one, open the new one, relink the backend if
necessary using Tools... Database Utilities... Linked Table Manager,
and they're now using the changed frontend with their own data.

It's MUCH harder with a single database: you'll need to (carefully!)
rename existing forms, queries, and other such objects, import them
from the modified database using File... Get External Data... Import,
grumble and gripe when this breaks some other part of the application,
debug, redo the import of that pesky subform, ... (can you tell I've
done this before...!?)

John W. Vinson[MVP]
 
Top