VBA code/style equivalent

[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

 

[bumble]

just


look at the vb code1.com

and clear your doubts....

 

[Cor Ligthert[MVP]]

John,

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

Cor

 

[Jesús López]

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

 

[Guest]

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?

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