VBA code/style equivalent

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi

I am synchronising one access db with its master via the below code;

Dim dbSynch As DAO.Database

Set dbSynch = DBEngine(0).OpenDatabase(<path local>)
dbSynch.Synchronize <path remote>

dbSynch.Close
Set dbSynch = Nothing

How can I do this in vb.net/ado.net?

Thanks

Regards
 
John,

There should be very rare circumstances that you want this.
Use AdoNet

Cor
 
There is no built in support for Access replication in ADO.NET. Therefore,
to syncrhonize two o more Access databases from VB.NET code you must use DAO
or JRO (Jet Replication Objects) through COM Interop.

Regards
 
Hi

I am synchronising one access db with its master via the below code;

Dim dbSynch As DAO.Database

Set dbSynch = DBEngine(0).OpenDatabase(<path local>)
dbSynch.Synchronize <path remote>

dbSynch.Close
Set dbSynch = Nothing

How can I do this in vb.net/ado.net?
Click to expand...


You can look at using Microsoft Synchronization Services for ADO.NET. It's
currently in CTP1.
 
Back
Top