Replicating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vadimbar - 14 Aug 2007 20:46 GMT

Fokls first I would like to thank you this site is always very helpfull.

I have a FE and BE on the server I created a replica file of the BE which is
strictly all tables.
So now on the server I have tables_only.mdb, Replicatables_only.mdb and
form.mdb

I copied the FE and BE on to the laptop (tables_only.mdb and form.mdb).
Modified the link table manager to access the tables on the laptop. I want to
sync what is the correct method?

On the laptop
When I want to sync I need to exit out of form.mdb and open my
tables_only.mdb then specifiy the location of my tables_only.mdb on the
server? Is this the correct way of performing a synch?

Reply to this Message

David W. Fenton - 15 Aug 2007 18:32 GMT

> Fokls first I would like to thank you this site is always very
> helpfull.
[quoted text clipped - 12 lines]
> tables_only.mdb then specifiy the location of my tables_only.mdb
> on the server? Is this the correct way of performing a synch?

Sure. The dropdown list in the Access UI will give you all the
replicas that you can synch with.

Had you tried what you described, you would have found that it
worked, so I suspect you have a different question, perhaps?

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message

Vadimbar - 29 Aug 2007 19:24 GMT

Yes your right I do. How can I kick off a replication with out having to exit
my main form?

> > Folks first I would like to thank you this site is always very
> > helpfull.
[quoted text clipped - 18 lines]
> Had you tried what you described, you would have found that it
> worked, so I suspect you have a different question, perhaps?

Reply to this Message

David W. Fenton - 04 Sep 2007 23:24 GMT

> How can I kick off a replication with out having to exit
> my main form?

Create a command button on the main form that executes this code:

Dim db As DAO.Database

Set db = DBEngine.OpenDatabase("C:\MyBackEndReplica.mdb")
db.Synchronize "C:\MyOtherReplica"

db.Close
Set db = Nothing

Now, of course, you would want some error handling, and perhaps
would want to check for conflicts and so forth, but that's the
basics.

Signature

David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Reply to this Message

Vadimbar - 05 Sep 2007 00:00 GMT

Thanks David I will try this out as I get back to the office.

> > How can I kick off a replication with out having to exit
> > my main form?
[quoted text clipped - 12 lines]
> would want to check for conflicts and so forth, but that's the
> basics.

Reply to this Message