Re: MS Security Patches Breaks Internet Synchronization

From: Vitalijus J. Karalius (vjk_at_nospam.pls)
Date: 04/21/04

  • Next message: NQuinn: "Windows ME" 
    Date: Wed, 21 Apr 2004 07:24:13 -0700

    Fails with "Invalid HTTP address".
    Originially posted: 2003-09-23 - issue remains after subsequent
    patches....... does not affect all replicated databases.

    An issue with replication and Jet 4 SP-7 has come up a couple of times
    recently - and we have come accross the issue also.

    We have an NT box running Access2000 with Jet SP-6 and a Win2K box at SP-4
    (includes Jet SP-7) with Access2000.

    Same replica set - the NT 4 internet replication works via Access interface,
    the Win2K does not. Fails with "Invalid HTTP address". We know this is
    incorrect, as it is the same address as on the NT box.

    Both boxes have the same firewall - the NT 4 box firewall logs the access
    for synch - the Win2K firewall never even sees a request. Access displays
    the "Synchronization Status... Establishing Internet connection..." and then
    promptly throws the "Invalid HTTP address" warning.

    On the Win2K box, Jet 3 internet synchs - to the identical address and
    server - log through the firewall and complete without issues.

    The conclusion would be that SP-7 does break internet replication in Jet 4,
    unless there is some stealth permissions/security issue with the Win2K
    config.

    Anyone have any thoughts on this or about the proper way to roll back to
    SP-6 on Jet 4?

    "Mike Wachal" <mikewa@online.microsoft.com> wrote in message
    news:1ix6mugywp2qa$.117wyodgq1en.dlg@40tude.net...
    > Hi Kim,
    >
    > Are you by chance using partial replicas when you are having problems with
    > your syncronization? We have discovered an issue related to the Jet
    > security update that cause problems when synchronizing partial replicas
    > when the filter property that defines the partial uses field names that
    are
    > not surounded by brackets. The Partial Replica wizard included in Access
    > automatically includes the brackets, so this issue would only occur if you
    > created your partial replica via VBA code and did not delimite your field
    > names in the filter with brackets.
    >
    > For example, if you created a partial replica using a filter such as:
    >
    > Country = "USA"
    >
    > it would cause the problem you are seeing. We are working on a fix for
    this
    > issue, but it will take some time to be released. In the mean time, you
    > should be able to correct this problem by modifying the filters in any
    > affected partial replicas to include brakets around your field names and
    > then call the PopulatePartial method to re-populate the replica. For
    > example, the above described filter would be changed to:
    >
    > [Country] = "USA"
    >
    > If you are not using a partial replica when seeing this problem, let me
    > know and we'll continue work this problem.
    >
    > --
    > Regards,
    > Mike Wachal
    > Microsoft Corporation
    >
    > This posting is provided "AS IS" with no warranties, and confers no
    rights.
    >
    > On Sat, 17 Apr 2004 10:22:47 -0700, Kim Loeb wrote:
    >
    > > OK, I've isolated the culprit. It is MS04-014
    > > Vulnerability in the Microsoft Jet Database Engine Could
    > > Allow Code Execution (837001).
    > >
    > > http://www.microsoft.com/technet/security/bulletin/ms04-
    > > 014.mspx
    > >
    > > I unistalled this patch and synchronization works again.
    > >
    > > Hello Michael, who should I contact at MS to make them
    > > aware of this problem?
    > >
    > > Thanks,
    > > Kim
    > > krloeb@-remove-envirosolve.com
    > >
    > >>
    > >>Hope you post back when you determine which is the
    > > culprit.
    > >>
    > >>
    > >>.
    > >>
    >

  • Next message: NQuinn: "Windows ME"

    Relevant Pages

    • Re: Replication and VB
      ... > and writes directly to the database on the server. ... wouldn't work anyway, as linked tables are Access objects, not Jet, ... It would worry me, but if you can synch successfully via DAO, you're ... You can copy the replica to set up the laptop, but after that, you ...
      (microsoft.public.access.replication)
    • Re: Automatic change of replication filter
      ... a user with a partial replica replicates with a full ... The filter in the partial replica is e.g. ... You need a table of users that maps regions to users. ...
      (microsoft.public.access.replication)
    • Re: Synchronization Failure
      ... I've been having multiple issues with synchronization and I'm ... I have a database that records legal claims ... while the replica ... The reason it doesn't work is because replication is a Jet ...
      (microsoft.public.access.replication)
    • Re: Is there a way to tell if two replicas need to be synced without starting the sync process
      ... and the server replica. ... corruption rarely if ever occurs from simply reading table values, ... Jet writes a flag indicating whether or not the connection ...
      (microsoft.public.access.replication)
    • Re: Indirect Rep & Search Key Not Found Error
      ... We've got the latest Jet, MDAC, Office 2003 SP1, ... Last night I created replica farms on every machine in the ... network, because yesterday the Hub Backend that the fixed ... >> synchronizer indirectly synchronized with other ...
      (microsoft.public.access.replication)