Database Sync

W

Wayne

Hello,

not sure which group I should submit this to, so apologies if this is the
wrong one.

I have a database that I have replicated over 4 machines, I need these to
sync up every night when all users or out of the office. Is there a setting
I can enable to do this or do I have to set it up programatically?

Thanks
 
L

Lynn Trapp

When you say you have "replicated" the database what do you mean? Did you
just make a copy of the database to the 4 machines? If so, then you will
have to write a routine to handle that synchronization. I warn you that it
will not be an easy process, especially if you have used AutoNumber fields
for any of the tables.

Access does have built in replication. If you are interested in doing that,
then you may want to post your question in
microsoft.public.access.replication
 
G

George Nicholson

There is a Replication Manager that came with the Office XP Developer
Edition. (Not sure about other Office versions or VSTO, or if it available
outside of Developer tools).

It allows you to set up a Synchonization schedule (among other things). Once
it is managing replicas it also provides information on the past xx
synchronizations it has done: how many records or design changes
sent/received/deleted, success/failure & why failed, etc.

You also might want to look at
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=9#9 , especially if
you are "rolling your own" code. The Access xx Developers Handbook (Sybex:
Getz, et al) also has a good chapter on replication code, if you need it.

HTH,
 
Top