Re: MS Security Patches Breaks Internet Synchronization

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Mike Wachal (mikewa_at_online.microsoft.com)
Date: 04/20/04 

Date: Tue, 20 Apr 2004 14:25:49 -0700

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.
>>
>>
>>.
>>

Relevant Pages

  • Re: Partial Replication
    ... This partial replica has been used for the last> month everyday and suddenly it fails. ... What can trigger a> partial replica to change even though the filter has not> changed? ... What is the other salesman,> then? ... >>> tblsalesman is the primary table in the database. ...
    (microsoft.public.access.replication)
  • Re: Partial Replication
    ... Today I was informed that another partial replica ... >> Both have the identical filter listed below. ... >> tblsalesman is the primary table in the database. ...
    (microsoft.public.access.replication)
  • Re: Partial Replication
    ... I would have to wonder what are the other partial replica properties ... > I've recreated a new partial replica with the same> settings and saleman intials. ... > This time I compress and compacted the managed database> before making this replica and I also immediately> replicated the partial replica directly, rather than> using the interenet and the filter is working. ... > I would only get one other salesman, ...
    (microsoft.public.access.replication)
  • Re: key is already associated
    ... What is the filter and what records went through the filter that were not ... Globalization Infrastructure and Font Technologies ... >> I made a partial replica. ...
    (microsoft.public.access.replication)
  • Re: MS Security Patches Breaks Internet Synchronization
    ... An issue with replication and Jet 4 SP-7 has come up a couple of times ... The Partial Replica wizard included in Access ... > names in the filter with brackets. ...
    (microsoft.public.access.replication)