vb.net equivalent

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 19 Jan 2008 22:31 GMT

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

Reply to this Message

Tom van Stiphout - 19 Jan 2008 23:08 GMT

Not ADO.NET, but you can continue to use DAO via COM Interop.
-Tom.

>Hi
>
[quoted text clipped - 13 lines]
>
>Regards

Reply to this Message

David W. Fenton - 20 Jan 2008 22:45 GMT

> I am synchronising one access db with its master via the below
> code;
[quoted text clipped - 8 lines]
>
> How can I do this in vb.net/ado.net?

Using DAO that ought to work. I don't know how you use DAO in .NET.

You might find JRO easier, since it was designed for use with ADO
(though not ADO.NET).

Signature

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

Reply to this Message