Replicate the database using Access first ( assuming you have already done
that... )

I then have this working

Sub synchronise()
Dim db As Database
Set db = OpenDatabase("\\Server1\Public\Excel Applications\DoorControl\New
Folder\Replica of DoorControl.mdb")
db.Synchronize ("\\server2\Public\Excel
Applications\DoorControl\Doorcontrol.mdb")

End Sub


Sub TimedLoop()

Dim PauseTime, Start, Finish, TotalTime

    PauseTime = 900    ' Set duration.
    Start = Timer    ' Set start time.
    Do While Timer < Start + PauseTime
        DoEvents    ' Yield to other processes.
        Application.StatusBar = (Int(Start) + PauseTime) - Int(Timer) & "
until Synchronization"
    Loop
    
    Finish = Timer    ' Set end time.
    TotalTime = Finish - Start    ' Calculate total time.
    synchronise
    TimedLoop
End Sub

Regards

Sean
 -----Original Message-----
From: 	nitai [mailto:nitai@s...] 
Sent:	Wednesday 23 October 2002 12:48
To:	professional vb
Subject:	[pro_vb] Re: Synchonization Access Database

Hi Kaith,

Thanks for the reply. But i Dont want to drops the tables. I just want to
update,add or delete records which has been done at my live server and vice
versa

bye
NM

-----Original Message-----
From: Keith Bamberger [mailto:keith@p...]
Sent: Wednesday, October 23, 2002 3:15 PM
To: professional vb
Subject: [pro_vb] Re: Synchonization Access Database


Do you want to synchronise
just 1 way? (Live to local)

If I remember correctly you can import tables
from 1 Access DB to another. You could probably
automate this process dropping all your
current tables in your local version and
then importing over all the data from the
live DB. 1 Problem could be though that
depending on the size of your Access DB it
could take a while locking it from the live
servers use or perhaps at least causing
some problems.

Theres a clue as to where to start looking.
I hope it is of some help even though its
not much.

//Keith



---
Visual C# - A Guide for VB6 Developers
This book will make it easy to transfer your skills
from Visual Basic 6 to C#, the language of choice
of the .NET Framework.
http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059




---
Visual C# - A Guide for VB6 Developers
This book will make it easy to transfer your skills 
from Visual Basic 6 to C#, the language of choice 
of the .NET Framework.
http://www.wrox.com/ACON11.asp?ISBN=1861007175&p2p0059