Konrad
Sun Aug 31 23:39:57 CDT 2003
In JRO I have done that by now after reading articles
pointed by you previously.
Thanks
Konrad
"Kevin Sun [MS]" <zhisun@onlinemicrosoft.com> wrote in message
news:b1Cb6oCcDHA.1996@cpmsftngxa06.phx.gbl...
> 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" <konrad007@poczta.onet.pl>
> | 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: <bihp3o$eil$1@atlantis.news.tpi.pl>
> | References: <bhspl1$t85$1@nemesis.news.tpi.pl>
> <bhsrt1$8ma$1@nemesis.news.tpi.pl> <NQPDWkwZDHA.216@cpmsftngxa06.phx.gbl>
> <IbzYIyXaDHA.2296@cpmsftngxa06.phx.gbl>
> | 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: usenet@tpi.pl
> | 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
> |
> | "Kevin Sun [MS]" <zhisun@onlinemicrosoft.com> wrote in message
> | news:IbzYIyXaDHA.2296@cpmsftngxa06.phx.gbl...
> | > 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: <bhspl1$t85$1@nemesis.news.tpi.pl>
> | > <bhsrt1$8ma$1@nemesis.news.tpi.pl>
> | > | MIME-Version: 1.0
> | > | Content-Type: text/plain
> | > | Content-Transfer-Encoding: 7bit
> | > | From: zhisun@onlinemicrosoft.com (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: <NQPDWkwZDHA.216@cpmsftngxa06.phx.gbl>
> | > | 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" <konrad007@poczta.onet.pl>
> | > | | 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: <bhsrt1$8ma$1@nemesis.news.tpi.pl>
> | > | | References: <bhspl1$t85$1@nemesis.news.tpi.pl>
> | > | | 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: usenet@tpi.pl
> | > | | 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?)
> | > | |
> | > | | "Konrad" <konrad007@poczta.onet.pl> wrote in message
> | > | | news:bhspl1$t85$1@nemesis.news.tpi.pl...
> | > | | > Hi
> | > | | >
> | > | | > Can you point me examples
> | > | | > how to synchronize two databases
> | > | | > via internet?
> | > | | >
> | > | | > Thanks
> | > | | > Konrad
> | > | | >
> | > | | >
> | > | |
> | > | |
> | > | |
> | > |
> | > |
> | >
> |
> |
> |
>