synchronize access databases

  • Thread starter Thread starter Konrad
  • Start date Start date
K

Konrad

Hi

Can you point me examples
how to synchronize two databases
via internet?

Thanks
Konrad
 
Regarding the Access database replication over Internet, I suggest you to
refer the following good materials:

Q282977 ACC2000: Microsoft Access 2000 Replication FAQ Available
http://support.microsoft.com/support/kb/articles/q282/9/77.asp

Q190766 ACC2000: Jet 4.0 Replication White Papers Available on MSDN
http://support.microsoft.com/support/kb/articles/q190/7/66.asp

Internet Synchronization with the Microsoft Jet Database Engine: A
Technical Overview
http://msdn.microsoft.com/library/backgrnd/html/intrjet4.htm

170595.KB.EN-US ODE97: Correct Syntax for Internet Synchronization Using DAO
http://support.microsoft.com/default.aspx?scid=KB;EN-US;170595

Sincerely,

Kevin
Microsoft Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

--------------------
| From: "Konrad" <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Subject: Re: synchronize access databases
| Date: Tue, 19 Aug 2003 11:49:25 +0200
| Organization: tp.internet - http://www.tpi.pl/
| Lines: 18
| Message-ID: <[email protected]>
| References: <[email protected]>
| NNTP-Posting-Host: pj12.szczecin.sdi.tpnet.pl
| X-Trace: nemesis.news.tpi.pl 1061286627 8906 217.98.201.12 (19 Aug 2003
09:50:27 GMT)
| X-Complaints-To: (e-mail address removed)
| NNTP-Posting-Date: Tue, 19 Aug 2003 09:50:27 +0000 (UTC)
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.0
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!newsfee
d01.sul.t-online.de!t-online.de!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!
news.tpi.pl!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:58607
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| I'am intereseted two cases.
| 1. Serwer-klient
| 2.Klient-klient (is it possible?)
|
| | > Hi
| >
| > Can you point me examples
| > how to synchronize two databases
| > via internet?
| >
| > Thanks
| > Konrad
| >
| >
|
|
|
 
Hi,
I know for sure that both SocketPro and RDB at www.udaparts.com will
work for you. Why don't you give them a try?

--
Yuancai (Charlie) Ye
RDB, a tool for fast and securely accessing remote databases with dial-up,
cable, DSL and wireless modems anywhere

Fast and securely accessing all of remote data sources anywhere with
SocketPro using batch/queue, non-blocking and parallel computation

See 30 well-tested and real OLEDB examples
www.udaparts.com
 
Yes. I'am looking for
good replication
which can help me to
take two dosconnected databases up to date.
Process of replication will be done at night after
all day long work.

Thanks
Konrad

Kevin Sun said:
So do you want to implement replication of the Access database by using
ADO.NET?

Sincerely,

Kevin
Microsoft Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

--------------------
| X-Tomcat-ID: 259101555
| References: <[email protected]>
<[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: (e-mail address removed) (Kevin Sun [MS])
| Organization: Microsoft
| Date: Wed, 20 Aug 2003 10:51:47 GMT
| Subject: Re: synchronize access databases
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Lines: 58
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:58715
| NNTP-Posting-Host: TOMCATIMPORT2 10.201.218.182
|
| Regarding the Access database replication over Internet, I suggest you to
| refer the following good materials:
|
| Q282977 ACC2000: Microsoft Access 2000 Replication FAQ Available
| http://support.microsoft.com/support/kb/articles/q282/9/77.asp
|
| Q190766 ACC2000: Jet 4.0 Replication White Papers Available on MSDN
| http://support.microsoft.com/support/kb/articles/q190/7/66.asp
|
| Internet Synchronization with the Microsoft Jet Database Engine: A
| Technical Overview
| http://msdn.microsoft.com/library/backgrnd/html/intrjet4.htm
|
| 170595.KB.EN-US ODE97: Correct Syntax for Internet Synchronization Using
DAO
| http://support.microsoft.com/default.aspx?scid=KB;EN-US;170595
|
| Sincerely,
|
| Kevin
| Microsoft Support
|
| This posting is provided "AS IS" with no warranties, and confers no
rights.
| Get Secure! - www.microsoft.com/security
|
| --------------------
| | From: "Konrad" <[email protected]>
| | Newsgroups: microsoft.public.dotnet.framework.adonet
| | Subject: Re: synchronize access databases
| | Date: Tue, 19 Aug 2003 11:49:25 +0200
| | Organization: tp.internet - http://www.tpi.pl/
| | Lines: 18
| | Message-ID: <[email protected]>
| | References: <[email protected]>
| | NNTP-Posting-Host: pj12.szczecin.sdi.tpnet.pl
| | X-Trace: nemesis.news.tpi.pl 1061286627 8906 217.98.201.12 (19 Aug 2003
| 09:50:27 GMT)
| | X-Complaints-To: (e-mail address removed)
| | NNTP-Posting-Date: Tue, 19 Aug 2003 09:50:27 +0000 (UTC)
| | X-Priority: 3
| | X-MSMail-Priority: Normal
| | X-Newsreader: Microsoft Outlook Express 6.00.3790.0
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| | Path:
|
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!newsfee
d01.sul.t-online.de!t-online.de!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!
| news.tpi.pl!not-for-mail
| | Xref: cpmsftngxa06.phx.gbl
microsoft.public.dotnet.framework.adonet:58607
| | X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| |
| | I'am intereseted two cases.
| | 1. Serwer-klient
| | 2.Klient-klient (is it possible?)
| |
| | | | > Hi
| | >
| | > Can you point me examples
| | > how to synchronize two databases
| | > via internet?
| | >
| | > Thanks
| | > Konrad
| | >
| | >
| |
| |
| |
|
|
 
I have post the following information on 8/25. ADO.NET doesn't provided
method to replicate/compact Access db; however, you can accomplish this by
using JRO.

Please refer to the following article:

306287.KB.EN-US HOW TO: Compact a Microsoft Access Database by Using Visual
Basic .NET
http://support.microsoft.com/default.aspx?scid=KB;EN-US;306287

================================
Neither ActiveX Data Objects (ADO) nor ADO .NET provide the means to
compact or repair Microsoft Access databases. However, you can accomplish
this task by using the Microsoft Jet OLE DB Provider and Replication
Objects (JRO) that was introduced with Microsoft Data Access Components
(MDAC) version 2.1. ADO .NET allows the use of COM-based object libraries
through the Interop layer.



This article demonstrates how to compact an Access database by using Visual
Basic .NET.




Requirements
------------

- Microsoft Visual Basic .NET

- Microsoft Jet and Replication Objects 2.1, 2.5, or 2.6 Library




Steps to Build Example
----------------------

1. Open a new Visual Basic .NET console application.

2. In the Solution Explorer window, right-click the References node and
select Add Reference.

3. In the Add Reference dialog box, click the COM tab and select
Microsoft Jet and Replication Objects 2.I Library. Click Select to add
it to the "Selected Components". Click OK.

4. A warning will be displayed if there is no wrapper found for the
selected library. Click Yes to generate a wrapper. Microsoft ActiveX
Data Objects Library (ADODB) and JRO references will be added to the
project's References.

5. In the Solution Explorer window, right-click Module1.vb and click
View Code.

6. Delete all of the code from the code window.

7. Copy the following code and paste it into the code window:


Module Module1

Sub Main()

Dim jro As JRO.JetEngine

jro = New JRO.JetEngine()

jro.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\nwind.mdb", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\NewNwind.mdb;Jet
OLEDB:Engine Type=5")

MsgBox("Finished Compacting Database!")
End Sub

End Module


8. Change the path to the Source and Destination .mdb files as
appropriate. Press F5 to build and run the project. The compacted
database will be in Access 2000 (Jet 4.0) format. For a different Jet
format, see "References."

=============================

HTH.


Sincerely,

Kevin
Microsoft Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

--------------------
| From: "Konrad" <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Subject: Re: synchronize access databases
| Date: Wed, 27 Aug 2003 10:11:17 +0200
| Organization: tp.internet - http://www.tpi.pl/
| Lines: 126
| Message-ID: <[email protected]>
| References: <[email protected]>
<[email protected]> <[email protected]>
<[email protected]>
| NNTP-Posting-Host: pj12.szczecin.sdi.tpnet.pl
| X-Trace: atlantis.news.tpi.pl 1061971901 14933 217.98.201.12 (27 Aug 2003
08:11:41 GMT)
| X-Complaints-To: (e-mail address removed)
| NNTP-Posting-Date: Wed, 27 Aug 2003 08:11:41 +0000 (UTC)
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.0
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!newsfee
d01.sul.t-online.de!t-online.de!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!
news.tpi.pl!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:59414
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| Yes. I'am looking for
| good replication
| which can help me to
| take two dosconnected databases up to date.
| Process of replication will be done at night after
| all day long work.
|
| Thanks
| Konrad
|
| | > So do you want to implement replication of the Access database by using
| > ADO.NET?
| >
| > Sincerely,
| >
| > Kevin
| > Microsoft Support
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| > Get Secure! - www.microsoft.com/security
| >
| > --------------------
| > | X-Tomcat-ID: 259101555
| > | References: <[email protected]>
| > <[email protected]>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain
| > | Content-Transfer-Encoding: 7bit
| > | From: (e-mail address removed) (Kevin Sun [MS])
| > | Organization: Microsoft
| > | Date: Wed, 20 Aug 2003 10:51:47 GMT
| > | Subject: Re: synchronize access databases
| > | X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| > | Message-ID: <[email protected]>
| > | Newsgroups: microsoft.public.dotnet.framework.adonet
| > | Lines: 58
| > | Path: cpmsftngxa06.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl
| microsoft.public.dotnet.framework.adonet:58715
| > | NNTP-Posting-Host: TOMCATIMPORT2 10.201.218.182
| > |
| > | Regarding the Access database replication over Internet, I suggest you
| to
| > | refer the following good materials:
| > |
| > | Q282977 ACC2000: Microsoft Access 2000 Replication FAQ Available
| > | http://support.microsoft.com/support/kb/articles/q282/9/77.asp
| > |
| > | Q190766 ACC2000: Jet 4.0 Replication White Papers Available on MSDN
| > | http://support.microsoft.com/support/kb/articles/q190/7/66.asp
| > |
| > | Internet Synchronization with the Microsoft Jet Database Engine: A
| > | Technical Overview
| > | http://msdn.microsoft.com/library/backgrnd/html/intrjet4.htm
| > |
| > | 170595.KB.EN-US ODE97: Correct Syntax for Internet Synchronization
Using
| > DAO
| > | http://support.microsoft.com/default.aspx?scid=KB;EN-US;170595
| > |
| > | Sincerely,
| > |
| > | Kevin
| > | Microsoft Support
| > |
| > | This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| > | Get Secure! - www.microsoft.com/security
| > |
| > | --------------------
| > | | From: "Konrad" <[email protected]>
| > | | Newsgroups: microsoft.public.dotnet.framework.adonet
| > | | Subject: Re: synchronize access databases
| > | | Date: Tue, 19 Aug 2003 11:49:25 +0200
| > | | Organization: tp.internet - http://www.tpi.pl/
| > | | Lines: 18
| > | | Message-ID: <[email protected]>
| > | | References: <[email protected]>
| > | | NNTP-Posting-Host: pj12.szczecin.sdi.tpnet.pl
| > | | X-Trace: nemesis.news.tpi.pl 1061286627 8906 217.98.201.12 (19 Aug
| 2003
| > | 09:50:27 GMT)
| > | | X-Complaints-To: (e-mail address removed)
| > | | NNTP-Posting-Date: Tue, 19 Aug 2003 09:50:27 +0000 (UTC)
| > | | X-Priority: 3
| > | | X-MSMail-Priority: Normal
| > | | X-Newsreader: Microsoft Outlook Express 6.00.3790.0
| > | | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | | Path:
| > |
| >
|
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!newsfee
| > |
| >
|
d01.sul.t-online.de!t-online.de!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!
| > | news.tpi.pl!not-for-mail
| > | | Xref: cpmsftngxa06.phx.gbl
| > microsoft.public.dotnet.framework.adonet:58607
| > | | X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| > | |
| > | | I'am intereseted two cases.
| > | | 1. Serwer-klient
| > | | 2.Klient-klient (is it possible?)
| > | |
| > | | | > | | > Hi
| > | | >
| > | | > Can you point me examples
| > | | > how to synchronize two databases
| > | | > via internet?
| > | | >
| > | | > Thanks
| > | | > Konrad
| > | | >
| > | | >
| > | |
| > | |
| > | |
| > |
| > |
| >
|
|
|
 
In JRO I have done that by now after reading articles
pointed by you previously.

Thanks
Konrad


Kevin Sun said:
I have post the following information on 8/25. ADO.NET doesn't provided
method to replicate/compact Access db; however, you can accomplish this by
using JRO.

Please refer to the following article:

306287.KB.EN-US HOW TO: Compact a Microsoft Access Database by Using Visual
Basic .NET
http://support.microsoft.com/default.aspx?scid=KB;EN-US;306287

================================
Neither ActiveX Data Objects (ADO) nor ADO .NET provide the means to
compact or repair Microsoft Access databases. However, you can accomplish
this task by using the Microsoft Jet OLE DB Provider and Replication
Objects (JRO) that was introduced with Microsoft Data Access Components
(MDAC) version 2.1. ADO .NET allows the use of COM-based object libraries
through the Interop layer.



This article demonstrates how to compact an Access database by using Visual
Basic .NET.




Requirements
------------

- Microsoft Visual Basic .NET

- Microsoft Jet and Replication Objects 2.1, 2.5, or 2.6 Library




Steps to Build Example
----------------------

1. Open a new Visual Basic .NET console application.

2. In the Solution Explorer window, right-click the References node and
select Add Reference.

3. In the Add Reference dialog box, click the COM tab and select
Microsoft Jet and Replication Objects 2.I Library. Click Select to add
it to the "Selected Components". Click OK.

4. A warning will be displayed if there is no wrapper found for the
selected library. Click Yes to generate a wrapper. Microsoft ActiveX
Data Objects Library (ADODB) and JRO references will be added to the
project's References.

5. In the Solution Explorer window, right-click Module1.vb and click
View Code.

6. Delete all of the code from the code window.

7. Copy the following code and paste it into the code window:


Module Module1

Sub Main()

Dim jro As JRO.JetEngine

jro = New JRO.JetEngine()

jro.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\nwind.mdb", _
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\NewNwind.mdb;Jet
OLEDB:Engine Type=5")

MsgBox("Finished Compacting Database!")
End Sub

End Module


8. Change the path to the Source and Destination .mdb files as
appropriate. Press F5 to build and run the project. The compacted
database will be in Access 2000 (Jet 4.0) format. For a different Jet
format, see "References."

=============================

HTH.


Sincerely,

Kevin
Microsoft Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

--------------------
| From: "Konrad" <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| Subject: Re: synchronize access databases
| Date: Wed, 27 Aug 2003 10:11:17 +0200
| Organization: tp.internet - http://www.tpi.pl/
| Lines: 126
| Message-ID: <[email protected]>
| References: <[email protected]>
<[email protected]> <[email protected]>
<[email protected]>
| NNTP-Posting-Host: pj12.szczecin.sdi.tpnet.pl
| X-Trace: atlantis.news.tpi.pl 1061971901 14933 217.98.201.12 (27 Aug 2003
08:11:41 GMT)
| X-Complaints-To: (e-mail address removed)
| NNTP-Posting-Date: Wed, 27 Aug 2003 08:11:41 +0000 (UTC)
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.3790.0
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!
news.tpi.pl!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:59414
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| Yes. I'am looking for
| good replication
| which can help me to
| take two dosconnected databases up to date.
| Process of replication will be done at night after
| all day long work.
|
| Thanks
| Konrad
|
| | > So do you want to implement replication of the Access database by using
| > ADO.NET?
| >
| > Sincerely,
| >
| > Kevin
| > Microsoft Support
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| > Get Secure! - www.microsoft.com/security
| >
| > --------------------
| > | X-Tomcat-ID: 259101555
| > | References: <[email protected]>
| > <[email protected]>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain
| > | Content-Transfer-Encoding: 7bit
| > | From: (e-mail address removed) (Kevin Sun [MS])
| > | Organization: Microsoft
| > | Date: Wed, 20 Aug 2003 10:51:47 GMT
| > | Subject: Re: synchronize access databases
| > | X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| > | Message-ID: <[email protected]>
| > | Newsgroups: microsoft.public.dotnet.framework.adonet
| > | Lines: 58
| > | Path: cpmsftngxa06.phx.gbl
| > | Xref: cpmsftngxa06.phx.gbl
| microsoft.public.dotnet.framework.adonet:58715
| > | NNTP-Posting-Host: TOMCATIMPORT2 10.201.218.182
| > |
| > | Regarding the Access database replication over Internet, I suggest you
| to
| > | refer the following good materials:
| > |
| > | Q282977 ACC2000: Microsoft Access 2000 Replication FAQ Available
| > | http://support.microsoft.com/support/kb/articles/q282/9/77.asp
| > |
| > | Q190766 ACC2000: Jet 4.0 Replication White Papers Available on MSDN
| > | http://support.microsoft.com/support/kb/articles/q190/7/66.asp
| > |
| > | Internet Synchronization with the Microsoft Jet Database Engine: A
| > | Technical Overview
| > | http://msdn.microsoft.com/library/backgrnd/html/intrjet4.htm
| > |
| > | 170595.KB.EN-US ODE97: Correct Syntax for Internet Synchronization
Using
| > DAO
| > | http://support.microsoft.com/default.aspx?scid=KB;EN-US;170595
| > |
| > | Sincerely,
| > |
| > | Kevin
| > | Microsoft Support
| > |
| > | This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| > | Get Secure! - www.microsoft.com/security
| > |
| > | --------------------
| > | | From: "Konrad" <[email protected]>
| > | | Newsgroups: microsoft.public.dotnet.framework.adonet
| > | | Subject: Re: synchronize access databases
| > | | Date: Tue, 19 Aug 2003 11:49:25 +0200
| > | | Organization: tp.internet - http://www.tpi.pl/
| > | | Lines: 18
| > | | Message-ID: <[email protected]>
| > | | References: <[email protected]>
| > | | NNTP-Posting-Host: pj12.szczecin.sdi.tpnet.pl
| > | | X-Trace: nemesis.news.tpi.pl 1061286627 8906 217.98.201.12 (19 Aug
| 2003
| > | 09:50:27 GMT)
| > | | X-Complaints-To: (e-mail address removed)
| > | | NNTP-Posting-Date: Tue, 19 Aug 2003 09:50:27 +0000 (UTC)
| > | | X-Priority: 3
| > | | X-MSMail-Priority: Normal
| > | | X-Newsreader: Microsoft Outlook Express 6.00.3790.0
| > | | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | | Path:
| > |
| >
|
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!newsfee
| > |
| >
|
d01.sul.t-online.de!t-online.de!newsfeed.tpinternet.pl!atlantis.news.tpi.pl!
| > | news.tpi.pl!not-for-mail
| > | | Xref: cpmsftngxa06.phx.gbl
| > microsoft.public.dotnet.framework.adonet:58607
| > | | X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
| > | |
| > | | I'am intereseted two cases.
| > | | 1. Serwer-klient
| > | | 2.Klient-klient (is it possible?)
| > | |
| > | | | > | | > Hi
| > | | >
| > | | > Can you point me examples
| > | | > how to synchronize two databases
| > | | > via internet?
| > | | >
| > | | > Thanks
| > | | > Konrad
| > | | >
| > | | >
| > | |
| > | |
| > | |
| > |
| > |
| >
|
|
|
 
Back
Top